topic Re: Linking table without circular creation in QlikView

Linking table without circular creation

priya2 — Fri, 07 Jun 2019 11:14:09 GMT

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
Sno	Name	Date
1	John	1/5/2019
2	Ram	2/5/2019
3	Syed	3/5/2019
4	Arun	4/5/2019

Table 2:

No	Name	Course	DOJ
1	John	BCA	1/5/2019
2	Ram	Bsc	2/5/2019
3	Syed	Msc	3/5/2019
4	Jai	Commerce	4/5/2019
5	Raj	BCA	4/5/2019

Table 3:

No2	Amt
1	1000
2	2000
3	3000
5	4000

Re: Linking table without circular creation

Claudiu_Anghelescu — Fri, 07 Jun 2019 16:06:55 GMT

Table1: Sno, Name, Date
Table2: No, Name, Course, DOJ
Table3: No, Amt

Re: Linking table without circular creation

Brett_Bleess — Wed, 10 Jul 2019 21:33:50 GMT

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