Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

nested loop

 

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

 

 

3 Replies

Re: nested loop

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


talk is cheap, supply exceeds demand
Not applicable

Re: nested loop

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.

Re: nested loop

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.


talk is cheap, supply exceeds demand