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

    Self join hierarchy

    saurabh desai

      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

       

       

       

      +A

           When you click on + sign it should show

        +B1

            Wehn you click on + sign it should show

           +C1

            +C2

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