Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

Link Key Logic

I have 3 tables shown below. While selecting Project# in Table 1, I am getting result in Table 2 correctly. But that is not reflecting in TABLE 3. For instance, highlighted in yellow color. 1C->C1,C2 with Status Complete in Table 2. But all status from Table 3 coming along with Table 2. If the status is Complete in Table 2, the Table 3 status should be Complete. But here both status are associated when selecting Complete in Table 2.

Table 1:                              


Project#

Parent ID

1

1A

1

1B

1

1C

1

1D

1

1E

  Table 2:


T2Parent ID

T2UID

T2Date

T2Status

1A

A1

22/10/2015

Complete

1A

A2

3/11/2015

In Complete

1B

B1

30/12/2015

Complete

1B

B2

21/11/2017

Complete

1C

C1

2/10/2017

Complete

1C

C2

13/04/2018

Complete

1D

D1

28/12/2015

In Complete

1D

D2

22/11/2017

Complete

1E

E1

20/10/2017

In Complete

1E

E2

22/10/2015

In Complete

Table 3:

T3Parent ID

T3UID

T3Date

T3 Status

blabla -1A

A1

24/10/2015

Complete

blabla-blabla -1A

A2

5/11/2015

In Complete

blabla-bla/ -bla -1B

B1

31/12/2015

Complete

blabla-bla* -bla -1B

B2

25/11/2017

Complete

blabla-bla/ -bla -1C

C1

4/10/2017

Complete

blabla-bla -bla -1C

C2

15/04/2018

Complete

blabla-bla/ -bla -1D

D1

38/12/2015

In Complete

blabla-bla/ -bla -1D

D2

25/11/2017

Complete

blabla-bla/ -bla -1E

E1

22/10/2017

In Complete

blabla-bla/ -bla -1E

E2

25/10/2015

In Complete

3 Replies
agigliotti
Partner - Champion
Partner - Champion

could you please explain better which field are you selecting and what's the output expected ?

rammuthiah
Creator III
Creator III
Author

If I select the highlighted ParentID in Table 1, result should come accordingly. But I am getting T3 Status as Complete and In Complete for T3 UID. The output I got shown below the excel data

T3Parent ID

T3UID

T3Date

T3 Status

blabla -1A

A1

24/10/2015

Complete

blabla-blabla -1A

A2

5/11/2015

In Complete

blabla-bla/ -bla -1B

B1

31/12/2015

Complete

blabla-bla* -bla -1B

B2

25/11/2017

Complete

blabla-bla/ -bla -1C

C1

4/10/2017

Complete

blabla-bla -bla -1C

C2

15/04/2018

Complete

blabla-bla/ -bla -1D

D1

38/12/2015

In Complete

blabla-bla/ -bla -1D

D2

25/11/2017

Complete

blabla-bla/ -bla -1E

E1

22/10/2017

In Complete

blabla-bla/ -bla -1E

E2

25/10/2015

In Complete

T3 UID   T3 Status

C1     -    Complete

C1     -    InComplete

C2     -    Complete

C2     -    InComplete

ArnadoSandoval
Specialist II
Specialist II

Hi Ram Muthiah,

Qlik Sense works by associations; column names associations; your logic should work if you alias the columns as show below:

table 1.Parent Id as [t2 ParentId]

table 2.T2Uid as T3Uid

HTH

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.