Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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

+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

1 Reply
Not applicable
Author

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