Hierarchy with missing some n-level

[Anonymous]

Hi all,

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

Level 1 - Director	Level 2 - Senior Manager	Level 3 - Manager	Level 4 -Junior	Selling
TOTAL				172000
Anton	-	-	-	5000
Anton	Jhon	-	-	3000
Anton	John	Leni	-	3200
Anton	Jhon	Leni	Jimy	2000
Anton	-	-	Tony	2500
Anton	-	Simon	Maxi	1000
Anton	Jhon	-	Sam	500

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

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

[Anonymous]

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 · Accepted solution]

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.

[Anonymous]

Hi Gysbert,

Thanks for your guide, it works correctly

Thanks & Regards,

Suryanto

[#6]

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.
Чтобы представить их в качестве дерева нужны указанные поля.