Discussion board where members can get started with Qlik Sense.
please help me on below hierarchies script and suggest where i did wrong.
I have a table it has two fields emp ID and reporting Manager ID
now am going to create hierarchy
LOAD Text([Emp No.]) as ID1,
Text([Reporting Manager Emp ID]) as RM
ID1 as Value,
ID1&'-ID1' as Node_ID,
RM&'-RM' as Parent_Node_ID
RM as Value,
RM&'-RM' as Node_ID,
Value as ID,
Value as Name,
Node_ID as Node_ID_H,
Parent_Node_ID as Parent_Node_ID_H