Pivot Table; Nested Data based on parent code

Jeagerock — Sat, 16 Nov 2024 00:42:20 GMT

Hey there!

Currently I am busy working on a Qlikview app in which I need to show a organisation structure. I tried figuring it all out using a pivot table through the chart wizard and load scripts, etc. However I just can not find the correct write out on how to do this. My data structure as collected within the application is as followed:

LOAD * INLINE [ id, teamCode, TeamName, niveauCode, parentCode 1 , 001 , Team A , OU-0 , - 2 , 002 , Team B , OU-0 , - 3 , 003 , Team B-2 , OU-1 , 002 4 , 004 , Team C , OU-0 , - 7 , 007 , Team E , OU-0 , - 8 , 008 , Team B-3 , OU-2 , 003 9 , 009 , Team E-3 , OU-2 , 010 10, A43 , Team E-4 , OU-3 , 009 11, 010 , Team E-1 , OU-1 , 007 12, 011 , Team E-5 , OU-5 , 012 13, 012 , Team E-6 , OU-4 , A43 14, A44 , Team E-7 , OU-3 , 009 ];

How does it needs to be displayed in a pivot table:

As all the teams are in one table and work with a parent code I already have a little to much time in it then originally planned, so any help would be appreciated!

Re: Pivot Table; Nested Data based on parent code

Brett_Bleess — Thu, 04 Jun 2020 14:14:01 GMT

Likely going to need extension to do that, here is a link to an old one, not sure it will work in the latest versions, but you can try it:

https://community.qlik.com/t5/QlikView-Documents/org-qar/ta-p/1482365

The following Design Blog post may be of some use too:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Regards,
Brett

topic Re: Pivot Table; Nested Data based on parent code in QlikView

Pivot Table; Nested Data based on parent code

Re: Pivot Table; Nested Data based on parent code