topic Re: Convert table columns into hierarchical structure in QlikView

Convert table columns into hierarchical structure

qliklearnervir — Sat, 16 Nov 2024 19:08:22 GMT

I have 1 table like the below structure :

Org:

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.

Re: Convert table columns into hierarchical structure

Brett_Bleess — Tue, 10 Mar 2020 20:33:10 GMT

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

Re: Convert table columns into hierarchical structure

Saravanan_Desingh — Fri, 15 May 2020 01:27:29 GMT

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 ];

Re: Convert table columns into hierarchical structure

Saravanan_Desingh — Fri, 15 May 2020 01:29:55 GMT

Please check my document for various options with example...

https://community.qlik.com/t5/QlikView-Documents/Hierarchy-LOAD-under-various-Arguments/ta-p/1486215