Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |