Employee Relationship Data

[Anonymous]

Hi

I need some help with a  HR file with Employee-Manager relationship. The data structure looks like below. What's the best way to reconstruct the organization chart? If I have an employee, how do I find all the people that reports to this person, not just his direct report? I know in SQL, we can do a self join with a recursive query. What's the best way to achieve this in Qlikview?

Thanks

Sample Data:  

Employee	Manager
Tom	N/A
James	Tom
Jennifer	Tom
Casey	Tom
Dana	James
Allen	James
Laura	Jennifer
Sol	Laura

[sunny_talwar · Accepted solution]

Read about Hierarchy here:

Hierarchies

Hierarchy in QlikView