Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm trying to rank hierarchies and I'm trying to write dimension.
Level=1 Manager,Level=2 Manager Helper ,Level=3 Employee
if selected level 1 show me level 2 names.
=if (LEVEL=2,if(LEVEL=1 and PRED=WORKNUM,NAME))
its not work:(
@krmvacar I don't know if it's possible do it directly at pivot table.
Maybe you have to consider do it in the script.
The way of your table is structured, you can use the "Org chart" like below: