how can see manager of manager data in pivot in Tree format.

[MMCGLAESASAA]

Hi All,

I am create a app in which i need to show manager of manager hierarchies data in Pivot tree format.

Please help me to sort out this issue.

Regards

ISME

[Saravanan_Desingh]

Can u show me a sample how your data looks like?

Or you can check the below example.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

[MMCGLAESASAA]

i used same Syntax but not working 

Hierarchy (NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])(loadstatement | selectstatement)

[Saravanan_Desingh]

Did u say that this example is not working?

tab1:
Hierarchy(NodeID, ParentID, NodeName, ParentName, NodeName, PathName, '/', Depth) 
LOAD * Inline [
NodeID, ParentID, NodeName
1, 4, London
2, 3, Munich
3, 5, Germany
4, 5, UK
5, , Europe
];

[Saravanan_Desingh]

Please make sure that you are using '/' and not '\' in your code.