Hierarchical / Org chart dataset

[juriengroot]

  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..

ID	Reports_To	Level
0_Peter
1_Klaas	0_Peter	1
2_Bart	1_Klaas	2
3_Marie	0_Peter	1
4_Ellen	3_Marie	2
5_Sander	2_Bart	3
6_Moniek	2_Bart	3
7_Kees	6_Moniek	4
8_Seb	3_Marie	2
9_Luis	7_Kees	5
10_Monica	4_Ellen	3

[kfoudhaily · Accepted solution]

hello,

please refer to this post;

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

regards,

[Anonymous]

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