Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

juriengroot
New 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
Contributor III

Re: Hierarchical / Org chart dataset

hello,

please refer to this post;

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

regards,

2 Replies
kfoudhaily
Contributor III

Re: Hierarchical / Org chart dataset

hello,

please refer to this post;

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

regards,

arunaerra
Contributor

Re: Hierarchical / Org chart dataset

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

Community Browser