Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do we use the content of two table in order to make the dashboard.
Hi Pooja,
All you have to do is use Qliks associative modelling to do this. Easiest way is to find a common field within both your sources, and ensure both the Linking field are the same name in both tables. This will create a link between the two tables, and then in the front end you can just add your dimension and measures.
I have done the same, but getting inappropriate data.
Dimension of which table we have to use after linking.?
Can you give us a sample of both tables?
Tomasz
Hello..
FYI,
- If you have tables with same structure Qlikview will concatinate tables automatically.
T1: | T2: | |||
Num | Sal | Num | Sal | |
1 | 100 | 4 | 1000 | |
2 | 200 | 5 | 2000 | |
3 | 300 | 6 | 3000 |
Script:
T1:
Load * from XXX;
T2:
Load * from YYY;
Result: | |
T1: | |
Num | Sale |
1 | 100 |
2 | 200 |
3 | 300 |
4 | 1000 |
5 | 2000 |
6 | 3000 |
- If you have tables with diffrent structure you have to do a force concatenate tables.
T1: | T2: | |||
Num | Sal | Num | Exp | |
1 | 100 | 4 | 1000 | |
2 | 200 | 5 | 2000 | |
3 | 300 | 6 | 3000 |
Script:
T1:
Load * from XXX;
Concatenate
T2:
Load * from YYY;
Result: | ||
T1: | ||
Num | Sale | Exp |
1 | 100 | |
2 | 200 | |
3 | 300 | |
4 | 1000 | |
5 | 2000 | |
6 | 3000 |
Note: When you Concatenate/Generate a relation, the common Field/Primary Key will be only one field(i.e. In the above example Num, from 2 tables, it is concatenated as one single field) .
Hi pooja,
Can you explain the data structure for the 2 tables you are trying to use together. If they are of same structure then we can concatenate. If not need to view the data structure.
Hi Pooja,
Check if maybe you have more than one name - identical column, because if you have than QlikView will create a systematic key based on a couple of columns and not based on the column you want as a 'Primary Key'.
In this case just change the name of the other identical columns.
You can use the dimension from both table