Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hierarchy with missing some n-level

Hi all,

currently I have some case, where i need to specified user level using hierarchy.

Level 1 - DirectorLevel 2 - Senior ManagerLevel 3 - ManagerLevel 4 -JuniorSelling
TOTAL172000
Anton---5000
AntonJhon--3000
AntonJohnLeni-3200
AntonJhonLeniJimy2000
Anton--Tony2500
Anton-SimonMaxi1000
AntonJhon-Sam500

is it possible to create something like what shown on the table? Since there is some junior level will direct report to the director and don't have manager or senior manager.

Thanks,

Suryanto

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Don't name them levels, because they are not. They are the distance between the reporting employee and the employee he/she reports to. Use the Roles as levels. Director is level 1, Senior Manager is level 2 etc.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

I think the easiest way is to create a new field Role that will contain the roles of the employees and that is not related to the reporting hierarchy.

Name, Role, ReportsTo

Anton, Director,

Jhon, Senior Manager, Anton

John, Senior Manager, Anton

Leni, Manager, John

Leni, Manager, Jhon

Simon, Manager, Anton

Jimy, Junior, Leni

Tony, Junior, Anton

Maxi, Junior, Simon

Sam, Junior, Jhon

With a table like this you can use the standard hierarchy() function to create your reporting hierarchy table.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hi Gysbert,

first of all thanks a lot for u'r response, but if i create the standard hierarchy function it will return me something like:

Level1     |Level2   |Level3      |Level4

Anton     | Jhon     |Leni         |Jimy

Anton     | Tony     |-              |-

Anton     |Simon    |Maxi        |-

which is each level shown wrong level, is there any specific way to seperate the level problem?

Thanks & Regards,

Suryanto

Gysbert_Wassenaar

Don't name them levels, because they are not. They are the distance between the reporting employee and the employee he/she reports to. Use the Roles as levels. Director is level 1, Senior Manager is level 2 etc.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hi Gysbert,

Thanks for your guide, it works correctly

Thanks & Regards,

Suryanto

Not applicable
Author

Show you how to add a table NodeID, ParentID and NodeName?

These tables are returned from SAP in QlikView.

In order to present them as a tree needs these fields.

Translated with Google Translate - Qlik Community Administrative Team

Подскажите, как в такую таблицу добавить NodeID, ParentID и NodeName ?
Такие таблицы возвращаются из SAP в QlikView.
Чтобы представить их в качестве дерева нужны указанные поля.