Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
could you please explain better which field are you selecting and what's the output expected ?
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
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