Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

1 Reply
Not applicable

Re: Self join hierarchy

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,


Community Browser