topic Re: Hierarchy problem in QlikView https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406753#M697773 <HTML><HEAD></HEAD><BODY><P>Please give me a the solution of the problem with .qvw file.........</P></BODY></HTML> Fri, 08 Feb 2013 09:24:00 GMT koushik_btech20 2013-02-08T09:24:00Z Hierarchy problem https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406751#M697771 <HTML><HEAD></HEAD><BODY><P>There is an account master table where I cannot make the proper hierarchy. What should be the parent and child node is very confusing to me..I am attaching the account master table. If anyone have the solution please share it.....</P></BODY></HTML> Tue, 05 Feb 2013 17:59:22 GMT https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406751#M697771 koushik_btech20 2013-02-05T17:59:22Z Re: Hierarchy problem https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406752#M697772 <HTML><HEAD></HEAD><BODY><P>It may look somethign like this: </P><P>I just picked '&gt;' this as a delimiter it can be anything you want.</P><P></P><P><SPAN class="Bold">Hierarchy (</SPAN>ACCNT_CODE,LOOKUP,ACCNT_NAME,'&gt;')</P><P></P><P></P><P>The syntax is:</P><P class="syntax"><SPAN class="Bold">Hierarchy (</SPAN><SPAN class="Italic"><STRONG>NodeID</STRONG>, ParentID, <STRONG>NodeName</STRONG>, [<STRONG>ParentName</STRONG>], [PathSource], [PathName], <STRONG>[PathDelimiter],</STRONG> [Depth]</SPAN><SPAN class="Bold">)</SPAN><SPAN class="Italic">(loadstatement | selectstatement)</SPAN> </P></BODY></HTML> Tue, 05 Feb 2013 20:03:15 GMT https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406752#M697772 2013-02-05T20:03:15Z Re: Hierarchy problem https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406753#M697773 <HTML><HEAD></HEAD><BODY><P>Please give me a the solution of the problem with .qvw file.........</P></BODY></HTML> Fri, 08 Feb 2013 09:24:00 GMT https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406753#M697773 koushik_btech20 2013-02-08T09:24:00Z Re: Hierarchy problem https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406754#M697774 <HTML><HEAD></HEAD><BODY><P>This hierarchy worked well for me. </P><P><SPAN class="Bold"></SPAN><SPAN class="Italic"><STRONG>NodeID</STRONG>, ParentID, <STRONG>NodeName</STRONG>, [<STRONG>ParentName</STRONG>], [PathSource], [PathName], <STRONG>[PathDelimiter],</STRONG> [Depth]</SPAN><SPAN class="Bold">)</SPAN><SPAN class="Italic">(loadstatement | selectstatement)</SPAN></P><P></P><P><BR /><A href="http://remodelproducts.com/bathroom-vanities/">Stylish Bathroom Vanities</A></P></BODY></HTML> Wed, 29 May 2013 06:16:39 GMT https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406754#M697774 2013-05-29T06:16:39Z Re: Hierarchy problem https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406755#M697775 <HTML><HEAD></HEAD><BODY><P>see the attached example of mine</P><P>hope it helps you</P></BODY></HTML> Wed, 29 May 2013 06:40:48 GMT https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406755#M697775 er_mohit 2013-05-29T06:40:48Z Re: Hierarchy problem https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406756#M697776 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P>If you understand this is not confusing I created demo which you will understand pretty well.</P><P></P><P>Hope this help you.</P><P></P><P>Vikas</P></BODY></HTML> Wed, 29 May 2013 06:43:36 GMT https://community.qlik.com/t5/QlikView/Hierarchy-problem/m-p/406756#M697776 vikasmahajan 2013-05-29T06:43:36Z