associate 3 tables in qlik sense

kbhasinptc — Tue, 27 Nov 2018 09:22:38 GMT

I have 3 tables in qlik sense all added through connection to a sql DB.

Table 1 and table 2 have a common key.

Table 2 and table 3 have another common key.

How do I associate table 1 and table 3 so that the pivot shows combination of data of table 1 and 3.

Re: associate 3 tables in qlik sense

kaushiknsolanki — Tue, 27 Nov 2018 09:51:07 GMT

Hi,

You dont need to worry when you connect table 1 with table 2 and table 2 with table 3.

By default Table 1 will be linked to table 3.

The default code should look like below.

Table1:

Load Table1Key,Table2Key from table1;

Table2:

Load Table3Key,Table2Key from table2;

Table3:

Load Table3Key from table3;

Regards,

Kaushik Solanki