Hi All,
Qlik provides a function Hierarchy in loading script
https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Hierarchy.htm
However, i would like to load the NodeItem in ascending order
which mean change the result from
| | |
| NodeID | ParentID | NodeName | NodeName1 | NodeName2 | NodeName3 | ParentName | PathName | Depth |
| 1 | 4 | London | Europe | UK | London | UK | Europe\UK\London | 3 |
| 2 | 3 | Munich | Europe | Germany | Munich | Germany | Europe\Germany\Munich | 3 |
| 3 | 5 | Germany | Europe | Germany | | Europe | Europe\Germany | 2 |
| 4 | 5 | UK | Europe | UK | | Europe | Europe\UK | 2 |
| 5 | | Europe | Europe | - | | - | Europe | |
to
|
| NodeID | ParentID | NodeName | NodeName1 | NodeName2 | NodeName3 | ParentName | PathName | Depth |
| 1 | 4 | London | London | UK | Europe | UK | Europe\UK\London | 3 |
| 2 | 3 | Munich | | Germany | Europe | Germany | Europe\Germany\Munich | 3 |
| 3 | 5 | Germany | | Germany | Europe | Europe | Europe\Germany | 2 |
| 4 | 5 | UK | | UK | Europe | Europe | Europe\UK | 2 |
| 5 | | Europe | | - | Europe | - | Europe |
Is it possible?
Best Regards,
Louis
