Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Parent Child Relationship hirarchy

Hi Community,

I have data like below.

  

Node_IDParent_ID
Ax00B000
Ax01Ax00
Ax02Ax00
Ax03Ax00
Ax04Ax03
Ax05Ax03
Bx06Ax02
Bx07

Ax02

and I am looking like below

 

ParentChild1Child2Child3
B000Ax00
Ax00Ax01Ax02Ax03
Ax01
Ax02Bx06Bx07
Ax03Ax04Ax05

Can some one help me to get loop/hirarchy for the above example.

-Priya

2 Replies
swuehl
MVP
MVP

You can look into the HIERARCHY and HIERARCHYBELONGSTO LOAD prefixes to transform your table:

Hierarchies

This will not exactely reproduce your output table, but will return tables that can be used well in QV analysis.

raju_insights
Partner
Partner

Hi Priya,

Hope this helps.

Hierar.JPG

PFA