Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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