Got a problem which I'm trying to work around in QlikView but currently can't manage it without some long nested IF statements. If there is an easier method using an uncommon QV function I'd love to know.
We have a list of employees with their managers (and their managers...etc) in a table (Emma Bradley being the owner of the company and top of the tree).
John Jennings Jennifer Ball Simon Atwal Emma Bradley
Richard Green Adam Lilienfeld Jennifer Ball Simon Atwal Emma Bradley
The resulting table I need to create from this is as follows.
Employee Name Lvl1Manager Lvl2Manager Lvl3Manager Lvl4Manager Lvl5Manager
John Jennings Emma Bradley Simon Atwal Jennifer Ball
Richard Green Emma Bradley Simon Atwal Jennifer Ball Adam Lilienfeld
Every employee in the company will have Emma Bradley as their Lv1Manager.
We're using a lot of structured IFs at the moment but thought I'd throw this on here to see if there are better suggestions.