Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zebhashmi
Valued Contributor

My Table has a loop reference

My Table has a loop reference

This question is Not Answered.(Mark as assumed answered)

Jahanzeb HashmiAce

IDFather nameName
1A
21B

By selecting 2 want to display its Father Name which is A in this Example.

1 Solution

Accepted Solutions
luismadriz
Valued Contributor

Re: My Table has a loop reference

Hi,

Please see if this is what you're after

I hope it helps,

Untitled.png

6 Replies
martinpohl
Valued Contributor II

Re: My Table has a loop reference

for that you need a hierarchy load

see help for more

Loading hierarchy data ‒ Qlik Sense

regards

mariusz_kumansk
New Contributor III

Re: My Table has a loop reference

loop.png

SampleData:

LOAD * Inline [

tmpID, tmpFatherName, tmpName

     1, , A

      2, 1, B

      3, 2, C

];



mapaFather:

Mapping LOAD

      tmpID,

      tmpName

Resident

      SampleData;


data:

LOAD

      tmpID as ID,

      ApplyMap('mapaFather', tmpFatherName) as FatherName,

      tmpName as Name

Resident

      SampleData;


DROP Tables SampleData;

mariusz_kumansk
New Contributor III

Re: My Table has a loop reference

or you can use hierarchy

zebhashmi
Valued Contributor

Re: My Table has a loop reference

Thank you but i can't do that in script as i have may felid in there want to do it in expression

Regards

JH

luismadriz
Valued Contributor

Re: My Table has a loop reference

Hi,

Please see if this is what you're after

I hope it helps,

Untitled.png

zebhashmi
Valued Contributor

Re: My Table has a loop reference

Thank you very much!