nested loop

[#1]

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

[Gysbert_Wassenaar]

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

[#3]

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.

[Gysbert_Wassenaar]

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.