Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 1 table like the below structure :
Org:
ID
Level1
Level2
Level3
Level4
Level5
Level6
Now i want to create a hierarchy to show data like Level1--> Level2-->Level3...........-->Level6
and want to connect with other tables with ID field.
finally, I want to create a perfect pivot table with these hierarchical columns.
please suggest.
Have a look at the following Design Blog posts:
https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325
If that does not quite get you there, here is the base URL for this area you can use to further search the other 700+ posts there, hopefully you can find something further to get you the rest of the way.
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett
You need Parent and Node column. Based on your data, I have created as below.
Org:
Hierarchy(ID, [Parent ID],Node,,ID)
LOAD *, ID As Node INLINE [
ID, Parent ID
Level1,
Level2, Level1
Level3, Level2
Level4, Level3
Level5, Level4
Level6, Level5
Level7, Level3
];
Please check my document for various options with example...
https://community.qlik.com/t5/QlikView-Documents/Hierarchy-LOAD-under-various-Arguments/ta-p/1486215