0 Replies Latest reply: Apr 5, 2017 2:56 AM by Louis Lam RSS

    Qlik Hierarchy

    Louis Lam

      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