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?
