Pivot Table; Nested Data based on parent code

[Jeagerock]

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!

[Brett_Bleess]

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