topic Re: Self join hierarchy in QlikView https://community.qlik.com/t5/QlikView/Self-join-hierarchy/m-p/267123#M497810 <HTML><HEAD></HEAD><BODY><P>I tried to interpet your requirement thru the attachement.</P><P>Loaded data as a delimited form. Used the same in list box using tree view with the delimitor.</P><P></P><P>Hope it helps,</P><P>Kiran</P></BODY></HTML> Fri, 21 Oct 2011 18:15:19 GMT 2011-10-21T18:15:19Z Self join hierarchy https://community.qlik.com/t5/QlikView/Self-join-hierarchy/m-p/267122#M497809 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>I have simple employee table.</P><P></P><P>like below</P><P></P><P>EmployeeID&nbsp;&nbsp;&nbsp;&nbsp; ManagerID&nbsp; Employeename</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B1</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C1</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C2</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D1</P><P>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Now in qlikview, i want to display the above hierarchy like below</P><P></P><P></P><P></P><P>+A</P><P>&nbsp;&nbsp;&nbsp;&nbsp; When you click on + sign it should show</P><P>&nbsp; +B1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wehn you click on + sign it should show</P><P>&nbsp;&nbsp;&nbsp;&nbsp; +C1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +C2</P><P>&nbsp;&nbsp;&nbsp;&nbsp; When you click on C1 it should showsD1 and when you click in C2 it should shows E1</P></BODY></HTML> Fri, 21 Oct 2011 18:08:53 GMT https://community.qlik.com/t5/QlikView/Self-join-hierarchy/m-p/267122#M497809 2011-10-21T18:08:53Z Re: Self join hierarchy https://community.qlik.com/t5/QlikView/Self-join-hierarchy/m-p/267123#M497810 <HTML><HEAD></HEAD><BODY><P>I tried to interpet your requirement thru the attachement.</P><P>Loaded data as a delimited form. Used the same in list box using tree view with the delimitor.</P><P></P><P>Hope it helps,</P><P>Kiran</P></BODY></HTML> Fri, 21 Oct 2011 18:15:19 GMT https://community.qlik.com/t5/QlikView/Self-join-hierarchy/m-p/267123#M497810 2011-10-21T18:15:19Z