Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following table:
Entry No. | Reference No. | Document No. |
1 | AAA | |
2 | BBB | |
3 | CCC | |
4 | 1 | DDD |
5 | 2 | EEE |
6 | 3 | FFF |
7 | 4 | GGG |
8 | 7 | HHH |
Entry No. is a unique Number. Entry nos 1 to 3 are staring numbers, the balance are linked numbers,. for eg. entry no 8 is linked to 7 which in turn is linked to 4, which in turn is linked to 1. Because there is no reference against 1, it is the the starting number
i wanted the results as below:
Entry No. | Reference No. | Document No. |
8 | 1 | AAA |
For entry no. 8, the links end at entry no. 1 and corresponding reference against 1 is AAA.
i got the output as required in the attachment.
Now i have made a small change.
Entry No. | Reference No. | Document No. |
1 | AAA | |
2 | BBB | |
3 | CCC | |
4 | 1 | DDD |
5 | 2 | EEE |
6 | 2 | FFF |
7 | 4 | GGG |
8 | 7 | HHH |
in the above table, for entry 5 and 6, the reference number is the same.
Now can anyone provide the answers in qliksense file
Please don't clutter this site with duplicate discussions: Nested loop
If you don't have enough patience to wait 7 minutes for an answer you should hire a paid consultant. You can demand a timely answer for a price then. And probably learn some patience as well.
I don't see the attachment you mentioned. But look up the Hierarchy script function. See for example this blog post (also applies to Qlik Sense): Unbalanced, n-level hierarchies
Dear Gysbert,
I am not duplicating the questions.
I have posted one for Qlikview and another for Qliksense.
I am using both and I am new to Qliksense.
That's why I asked this question.
Ok, fair enough. I hope you'll forgive me for calling you out on this. You didn't mention either Qlikview or Qlik Sense in your posts so they looked like dupes to me.