Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
priya2
Partner
Partner

Linking table without circular creation

Hi,

I need to link below tables without creating circular formation.

In table 1: i have sno,name and date fields.

In table 2: No,Name,Course,DOJ.

In table 3 :  No2  and Amt.

first I should link the table 1 and table 2 using Name column to get the Course and other values from table 2.

Also the link i should make between Table 1 and Table 3 using No column & Table 2 and Table 3 using No Column to get the Amt from Table 3.

Please help in achieving this.

Table 1:

Table 1
SnoNameDate
1John1/5/2019
2Ram2/5/2019
3Syed3/5/2019
4Arun

4/5/2019

 

Table 2:

NoNameCourseDOJ
1JohnBCA1/5/2019
2RamBsc2/5/2019
3SyedMsc3/5/2019
4JaiCommerce4/5/2019
5RajBCA4/5/2019

 

Table 3:

No2Amt
11000
22000
33000
54000

 

 

2 Replies
Claudiu_Anghelescu
Specialist
Specialist

Table1: Sno, Name, Date
Table2: No, Name, Course, DOJ
Table3: No, Amt
To help community find solutions, please don't forget to mark as correct.
Brett_Bleess
Support (Former)
Support (Former)

Just wanted to add the following as some further explanation as to why Claudiu's solution should work:

https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332

That is a Design Blob post from Henric Cronstrom explaining circular references and how to deal with them, so if Claudiu's post left you with any further questions, hopefully the above link will take care of those for you.

Decided to add one more as well, this one is regarding synthetic keys:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.