topic Help me on Creating Hierarchy in Data !!! in QlikView

Help me on Creating Hierarchy in Data !!!

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

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 — Mon, 11 Jun 2018 13:10:22 GMT

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 — Mon, 11 Jun 2018 20:26:18 GMT