create hierarchy

[Ayden]

hello need help in creating hierarchy report structure in qlik sense, which would show which would show which the following.

employee-supervisor-manager-director-senior director 

i have employee Id and supervisor ID.

or is it possible to have unique ID to create parent-sub Child hierarchy variable, where i can select a specific supervisor’s ID and it would return every employee which directly reports to them.

Thanks in advance.

[GaryGiles · Accepted solution]

You should look in the Hierarchy() function in your load to turn the adjacent nodes into the appropriate fields.

For the table that contains employee Id and supervisor ID, you add the Hierachy function prior to the loading of the table.  For example:

Hierarchy ([employee Id], [supervisor ID], Title)

Load *

from . . . .;

It will create a fields Title1, Title2, Title3, Title4 with the appropriate levels.  You can then rename the levels for your respective names.

rename field Title1 to Supervisor;

rename field Title2 to Manager;

etc.