My Table has a loop reference

[zebhashmi]

My Table has a loop reference

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

zebhashmi Dec 20, 2017 9:56 AM

ID	Father name	Name
1		A
2	1	B

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

[martinpohl]

for that you need a hierarchy load

see help for more

Loading hierarchy data ‒ Qlik Sense

regards

[mariusz_kumansk]

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]

or you can use hierarchy

[zebhashmi]

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 · Accepted solution]

Hi,

Please see if this is what you're after

I hope it helps,

[zebhashmi]

Thank you very much!