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

+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

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,

Kiran

Community Browser