Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
juriengroot
Contributor III
Contributor III

Hierarchical / Org chart dataset

  I have the following dataset as an example. My total set is +/- 2500 rows with our org chart. It contains unique rows that lead up to a hierarchical model. Is there an easy way to drill to the various lines and see who reports to who? Or is the only way to do that having a multi dimensional model, with Peter being level 1 as a dimension, Klaas en Marie as level 2 being a dimension etc..

 

IDReports_ToLevel
0_Peter
1_Klaas0_Peter1
2_Bart1_Klaas2
3_Marie0_Peter1
4_Ellen3_Marie2
5_Sander2_Bart3
6_Moniek2_Bart3
7_Kees6_Moniek4
8_Seb3_Marie2
9_Luis7_Kees5
10_Monica4_Ellen3
1 Solution

Accepted Solutions
kfoudhaily
Partner - Creator III
Partner - Creator III

hello,

please refer to this post;

https://community.qlik.com/docs/DOC-16552

regards,

QlikView Qlik Sense consultant

View solution in original post

2 Replies
kfoudhaily
Partner - Creator III
Partner - Creator III

hello,

please refer to this post;

https://community.qlik.com/docs/DOC-16552

regards,

QlikView Qlik Sense consultant
Anonymous
Not applicable

hi,

Try the below

Hierarchy(ID, [Reports To], Level, ParentName, Level, PathName, '\', Depth)

LOAD

ID,

[Reports To],

Level

FROM

[..\Downloads\Sales Multi Table.xlsx]

   (ooxml, embedded labels, table is Employees);