topic how in function hierarchy in NodeName columns fields load only PathName ? in QlikView https://community.qlik.com/t5/QlikView/how-in-function-hierarchy-in-NodeName-columns-fields-load-only/m-p/326552#M1184596 <HTML><HEAD></HEAD><BODY><P>Hi Sunil</P><P></P><P>Thanks for answer</P><P></P><P>I just load data </P><P><SPAN style=": ; font-size: 1;"></SPAN></P><P></P><P></P><P></P><P><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">Group:</SPAN></P><P><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">hierarchy</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Child</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> ,</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Parent</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">,</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Name</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">,,,'Path',,Depth)</SPAN></SPAN></P><P><SPAN style="color: black; font-size: 9pt; font-family: 'Courier New';"><STRONG style="color: blue; font-size: 9pt; font-family: 'Courier New';">LOAD</STRONG><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> </SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Child</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"><BR />&nbsp;&nbsp;&nbsp;&nbsp; ,</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Parent</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"><BR />&nbsp;&nbsp;&nbsp;&nbsp; ,</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Name</SPAN></SPAN></P><P><SPAN style="color: black; font-size: 9pt; font-family: 'Courier New';"><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;"> </SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">resident</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">&nbsp;&nbsp; <BR />Group_temp</SPAN></SPAN></SPAN></P><P></P><P>And columns (Name1,Name2...) generate from 5 to 10 depending database</P><P></P><P></P><P>Many thanks</P><P></P><P></P><P>Vilgis</P></BODY></HTML> Thu, 17 Nov 2011 14:01:23 GMT 2011-11-17T14:01:23Z how in function hierarchy in NodeName columns fields load only PathName ? https://community.qlik.com/t5/QlikView/how-in-function-hierarchy-in-NodeName-columns-fields-load-only/m-p/326550#M1184594 <HTML><HEAD></HEAD><BODY><P>Hello all</P><P></P><P>I just have problem</P><P></P><P>How in function hierarchy in NodeName columns fields load only PathName ?</P><P>Example :</P><P>column1 - All;column2 - All/; column3 - All//<SPAN class="hps">; </SPAN>column4 - All//<SPAN class="hps">/; </SPAN>column5 - All//<SPAN class="hps">//</SPAN></P><P>column1 - All;column2 - All/Group1; column3 - All/Group1/<SPAN class="hps">; </SPAN>column4 - All/Group1/<SPAN class="hps">/; </SPAN>column5 - All/Group1/<SPAN class="hps">//</SPAN></P><P>column1 - All;column2 - All/Group1; column3 - All/Group1/S<SPAN class="hps">ubgroup1; </SPAN>column4 - All/Group1/S<SPAN class="hps">ubgroup1/; </SPAN>column5 - All/Group1/S<SPAN class="hps">ubgroup1//</SPAN></P><P>column1 - All;column2 - All/Group1; column3 - All/Group1/S<SPAN class="hps">ubgroup2; </SPAN>column4 - All/Group1/S<SPAN class="hps">ubgroup2/Item1; </SPAN>column5 - All/Group1/S<SPAN class="hps">ubgroup1/Item1/</SPAN></P><P>column1 - All;column2 - All/Group1; column3 - All/Group1/S<SPAN class="hps">ubgroup2; </SPAN>column4 - All/Group1/S<SPAN class="hps">ubgroup2/Item1; </SPAN>column5 - All/Group1/S<SPAN class="hps">ubgroup1/Item2/</SPAN></P><P><SPAN class="hps"> </SPAN></P><P><SPAN class="hps">Thanks for answers </SPAN></P></BODY></HTML> Thu, 17 Nov 2011 13:35:57 GMT https://community.qlik.com/t5/QlikView/how-in-function-hierarchy-in-NodeName-columns-fields-load-only/m-p/326550#M1184594 2011-11-17T13:35:57Z how in function hierarchy in NodeName columns fields load only PathName ? https://community.qlik.com/t5/QlikView/how-in-function-hierarchy-in-NodeName-columns-fields-load-only/m-p/326551#M1184595 <HTML><HEAD></HEAD><BODY><P> why not you use </P><P></P><P></P><P>field1&amp;'/'&amp;field2&amp;'/'field3......&nbsp;&nbsp; as hierarchy&nbsp;&nbsp; </P><P>then take in listbox </P><P></P><P></P><P>general-check <STRONG>show as treeview</STRONG><STRONG> </STRONG>-&gt; with seperator&nbsp;&nbsp;&nbsp; <STRONG>/ or any seperator you want </STRONG></P></BODY></HTML> Thu, 17 Nov 2011 13:47:18 GMT https://community.qlik.com/t5/QlikView/how-in-function-hierarchy-in-NodeName-columns-fields-load-only/m-p/326551#M1184595 SunilChauhan 2011-11-17T13:47:18Z how in function hierarchy in NodeName columns fields load only PathName ? https://community.qlik.com/t5/QlikView/how-in-function-hierarchy-in-NodeName-columns-fields-load-only/m-p/326552#M1184596 <HTML><HEAD></HEAD><BODY><P>Hi Sunil</P><P></P><P>Thanks for answer</P><P></P><P>I just load data </P><P><SPAN style=": ; font-size: 1;"></SPAN></P><P></P><P></P><P></P><P><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">Group:</SPAN></P><P><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">hierarchy</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Child</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> ,</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Parent</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">,</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Name</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">,,,'Path',,Depth)</SPAN></SPAN></P><P><SPAN style="color: black; font-size: 9pt; font-family: 'Courier New';"><STRONG style="color: blue; font-size: 9pt; font-family: 'Courier New';">LOAD</STRONG><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> </SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Child</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"><BR />&nbsp;&nbsp;&nbsp;&nbsp; ,</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Parent</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"><BR />&nbsp;&nbsp;&nbsp;&nbsp; ,</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Name</SPAN></SPAN></P><P><SPAN style="color: black; font-size: 9pt; font-family: 'Courier New';"><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;"> </SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">resident</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">&nbsp;&nbsp; <BR />Group_temp</SPAN></SPAN></SPAN></P><P></P><P>And columns (Name1,Name2...) generate from 5 to 10 depending database</P><P></P><P></P><P>Many thanks</P><P></P><P></P><P>Vilgis</P></BODY></HTML> Thu, 17 Nov 2011 14:01:23 GMT https://community.qlik.com/t5/QlikView/how-in-function-hierarchy-in-NodeName-columns-fields-load-only/m-p/326552#M1184596 2011-11-17T14:01:23Z