Help me on Creating Hierarchy in Data !!!

[panipat1990]

Hi Team,

I have to make a hierarchy b/w Parent and Child Values/ID.

I have two columns in my Data. One is Parent ID and 2nd is Child ID. See in attached screenshot.

Based on dummy data which i attached here , needed to create 4 Hierarchy level as 4 columns.

Kindly suggest/help me how can i create hierarchy columns.

Thanks

Gourav

[lironbaram · Accepted solution]

hi

you can use this script

Hierarchy(Child_ID, Parent_ID, Title, ParentName, Title, PathName, '\', Depth)

LOAD Child_ID,

     Parent_ID,

     text(Child_ID) as Title

FROM

(ooxml, embedded labels, table is Sheet1);

[MarcoWedel]

see also:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

regards

Marco