Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

associate 3 tables in qlik sense

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.

1 Reply
MVP & Luminary
MVP & Luminary

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

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".