1 Reply Latest reply: Oct 21, 2011 2:15 PM by Kiran Rokkam RSS

    Self join hierarchy

      HI All,


      I have simple employee table.


      like below


      EmployeeID     ManagerID  Employeename


      1                         0           A

      2                         1           B1

      3                         2           C1

      4                         2           C2

      5                         3            D1

      6                         4            E1



      Now in qlikview, i want to display the above hierarchy like below





           When you click on + sign it should show


            Wehn you click on + sign it should show



           When you click on C1 it should showsD1 and when you click in C2 it should shows E1