topic Qlik Hierarchy in App Development https://community.qlik.com/t5/App-Development/Qlik-Hierarchy/m-p/1343517#M29706 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Qlik provides a function Hierarchy in loading script</P><P><A href="https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Hierarchy.htm" title="https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Hierarchy.htm">https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Hierarchy.htm</A></P><P></P><P>However, i would like to load the NodeItem in ascending order</P><P>which mean change the result from</P><P></P><TABLE data-mc-conditions="Targets.NotToTranslate" style="margin-bottom: 15px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"><TBODY style="border-top-width: 2px; border-top-color: #0f0f0f;"><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;"></TD><TD></TD><TD></TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">NodeID</TD><TD style="padding: 7px;">ParentID</TD><TD style="padding: 7px;">NodeName</TD><TD style="padding: 7px;">NodeName1</TD><TD style="padding: 7px;">NodeName2</TD><TD style="padding: 7px;">NodeName3</TD><TD style="padding: 7px;">ParentName</TD><TD style="padding: 7px;">PathName</TD><TD style="padding: 7px;">Depth</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">1</TD><TD style="padding: 7px;">4</TD><TD style="padding: 7px;">London</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">London</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;">Europe\UK\London</TD><TD style="padding: 7px;">3</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">2</TD><TD style="padding: 7px;">3</TD><TD style="padding: 7px;">Munich</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Munich</SPAN></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;">Europe\Germany\Munich</TD><TD style="padding: 7px;">3</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">3</TD><TD style="padding: 7px;">5</TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;">Europe\Germany</TD><TD style="padding: 7px;">2</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">4</TD><TD style="padding: 7px;">5</TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;">Europe\UK</TD><TD style="padding: 7px;">2</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">5</TD><TD style="padding: 7px;"> </TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">-</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">-</TD><TD style="padding: 7px;">Europe</TD><TD></TD></TR></TBODY></TABLE><P></P><P>to</P><P></P><TABLE data-mc-conditions="Targets.NotToTranslate" style="margin-bottom: 15px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"><TBODY style="border-top-width: 2px; border-top-color: #0f0f0f;"><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">NodeID</TD><TD style="padding: 7px;">ParentID</TD><TD style="padding: 7px;">NodeName</TD><TD style="padding: 7px;">NodeName1</TD><TD style="padding: 7px;">NodeName2</TD><TD style="padding: 7px;">NodeName3</TD><TD style="padding: 7px;">ParentName</TD><TD style="padding: 7px;">PathName</TD><TD style="padding: 7px;">Depth</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">1</TD><TD style="padding: 7px;">4</TD><TD style="padding: 7px;">London</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">London</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;">Europe\UK\London</TD><TD style="padding: 7px;">3</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">2</TD><TD style="padding: 7px;">3</TD><TD style="padding: 7px;">Munich</TD><TD style="padding: 7px;"><TABLE data-mc-conditions="Targets.NotToTranslate" style="margin-bottom: 15px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"><TBODY style="border-top-width: 2px; border-top-color: #0f0f0f;"><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">Munich</TD></TR></TBODY></TABLE></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;">Europe\Germany\Munich</TD><TD style="padding: 7px;">3</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">3</TD><TD style="padding: 7px;">5</TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;">Europe\Germany</TD><TD style="padding: 7px;">2</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">4</TD><TD style="padding: 7px;">5</TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;">Europe\UK</TD><TD style="padding: 7px;">2</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">5</TD><TD style="padding: 7px;"> </TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">-</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">-</TD><TD style="padding: 7px;">Europe</TD></TR></TBODY></TABLE><P></P><P>Is it possible?</P><P></P><P>Best Regards,</P><P>Louis</P><DIV> </DIV><DIV> </DIV></BODY></HTML> Wed, 05 Apr 2017 06:56:48 GMT Anonymous 2017-04-05T06:56:48Z Qlik Hierarchy https://community.qlik.com/t5/App-Development/Qlik-Hierarchy/m-p/1343517#M29706 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Qlik provides a function Hierarchy in loading script</P><P><A href="https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Hierarchy.htm" title="https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Hierarchy.htm">https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Hierarchy.htm</A></P><P></P><P>However, i would like to load the NodeItem in ascending order</P><P>which mean change the result from</P><P></P><TABLE data-mc-conditions="Targets.NotToTranslate" style="margin-bottom: 15px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"><TBODY style="border-top-width: 2px; border-top-color: #0f0f0f;"><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;"></TD><TD></TD><TD></TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">NodeID</TD><TD style="padding: 7px;">ParentID</TD><TD style="padding: 7px;">NodeName</TD><TD style="padding: 7px;">NodeName1</TD><TD style="padding: 7px;">NodeName2</TD><TD style="padding: 7px;">NodeName3</TD><TD style="padding: 7px;">ParentName</TD><TD style="padding: 7px;">PathName</TD><TD style="padding: 7px;">Depth</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">1</TD><TD style="padding: 7px;">4</TD><TD style="padding: 7px;">London</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">London</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;">Europe\UK\London</TD><TD style="padding: 7px;">3</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">2</TD><TD style="padding: 7px;">3</TD><TD style="padding: 7px;">Munich</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Munich</SPAN></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;">Europe\Germany\Munich</TD><TD style="padding: 7px;">3</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">3</TD><TD style="padding: 7px;">5</TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;">Europe\Germany</TD><TD style="padding: 7px;">2</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">4</TD><TD style="padding: 7px;">5</TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;">Europe\UK</TD><TD style="padding: 7px;">2</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">5</TD><TD style="padding: 7px;"> </TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">-</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">-</TD><TD style="padding: 7px;">Europe</TD><TD></TD></TR></TBODY></TABLE><P></P><P>to</P><P></P><TABLE data-mc-conditions="Targets.NotToTranslate" style="margin-bottom: 15px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"><TBODY style="border-top-width: 2px; border-top-color: #0f0f0f;"><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">NodeID</TD><TD style="padding: 7px;">ParentID</TD><TD style="padding: 7px;">NodeName</TD><TD style="padding: 7px;">NodeName1</TD><TD style="padding: 7px;">NodeName2</TD><TD style="padding: 7px;">NodeName3</TD><TD style="padding: 7px;">ParentName</TD><TD style="padding: 7px;">PathName</TD><TD style="padding: 7px;">Depth</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">1</TD><TD style="padding: 7px;">4</TD><TD style="padding: 7px;">London</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">London</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;">Europe\UK\London</TD><TD style="padding: 7px;">3</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">2</TD><TD style="padding: 7px;">3</TD><TD style="padding: 7px;">Munich</TD><TD style="padding: 7px;"><TABLE data-mc-conditions="Targets.NotToTranslate" style="margin-bottom: 15px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"><TBODY style="border-top-width: 2px; border-top-color: #0f0f0f;"><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">Munich</TD></TR></TBODY></TABLE></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;">Europe\Germany\Munich</TD><TD style="padding: 7px;">3</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">3</TD><TD style="padding: 7px;">5</TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">Germany</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;">Europe\Germany</TD><TD style="padding: 7px;">2</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">4</TD><TD style="padding: 7px;">5</TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">UK</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;">Europe\UK</TD><TD style="padding: 7px;">2</TD></TR><TR data-mc-conditions="" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD style="padding: 7px;">5</TD><TD style="padding: 7px;"> </TD><TD style="padding: 7px;">Europe</TD><TD style="padding: 7px;"></TD><TD style="padding: 7px;">-</TD><TD style="padding: 7px;"><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">Europe</SPAN></TD><TD style="padding: 7px;">-</TD><TD style="padding: 7px;">Europe</TD></TR></TBODY></TABLE><P></P><P>Is it possible?</P><P></P><P>Best Regards,</P><P>Louis</P><DIV> </DIV><DIV> </DIV></BODY></HTML> Wed, 05 Apr 2017 06:56:48 GMT https://community.qlik.com/t5/App-Development/Qlik-Hierarchy/m-p/1343517#M29706 Anonymous 2017-04-05T06:56:48Z