Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Employee Data Logic Issues

Hi,

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).

EmployeeName               ManagerL1          ManagerL2          ManagerL3          ManagerL4

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.

Thanks,

Adam

1 Solution

Accepted Solutions
AlbertoV
Contributor III

Re: Employee Data Logic Issues

You might find this helpful:

Hierarchies

2 Replies
AlbertoV
Contributor III

Re: Employee Data Logic Issues

You might find this helpful:

Hierarchies

Re: Employee Data Logic Issues

one example of hierarchy loads:

Using lookup

hope this helps

regards

Marco

Community Browser