Self join hierarchy

[#1]

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

[#2]

I tried to interpet your requirement thru the attachement.

Loaded data as a delimited form. Used the same in list box using tree view with the delimitor.

Hope it helps,

Kiran