There are various kinds of joins available but let's take a look at the various types of joins supported by Qlik Sense.
Let's consider the following tables to understand each type better:
- Order table: This table stores the order-related data:
|
OrderNumber |
Product |
CustomerID |
OrderValue |
|
100 |
Fruits |
1 |
100 |
|
101 |
Fruits |
2 |
80 |
|
102 |
Fruits |
3 |
120 |
|
103 |
Vegetables |
6 |
200 |
- Customer table: This table stores the customer details, which include the CustomerID and Name:
|
CustomerID |
Name |
|
1 |
Alex |
|
2 |
Linda |
|
3 |
Sam |
|
4 |
Michael |
|
5 |
Sara |