Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
tiklam_dynasys
Contributor

Qlik Hierarchy

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

NodeIDParentIDNodeNameNodeName1NodeName2NodeName3ParentNamePathNameDepth
14LondonEuropeUKLondonUKEurope\UK\London3
23MunichEuropeGermanyMunichGermanyEurope\Germany\Munich3
35GermanyEuropeGermanyEuropeEurope\Germany2
45UKEuropeUKEuropeEurope\UK2
5 EuropeEurope--Europe

to

NodeIDParentIDNodeNameNodeName1NodeName2NodeName3ParentNamePathNameDepth
14LondonLondonUKEuropeUKEurope\UK\London3
23Munich
Munich
GermanyEuropeGermanyEurope\Germany\Munich3
35GermanyGermanyEuropeEuropeEurope\Germany2
45UKUKEuropeEuropeEurope\UK2
5 Europe-Europe-Europe

Is it possible?

Best Regards,

Louis