Qlik Hierarchy

[Anonymous]

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