Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Creating hierarchy from simplified personnel file...

I have a very simple personnel file which lists EMP#, EMPName, MGR1# and MGR1Name for everyone in the company. From just this data, how can I then look-up the MGR# and use it as the EMP# to gain that person's MGR# and MGRName?  I keep getting circular references or synthetic keys.  FYI, I need 4 levels of MGRs so I will need to repeat the process and change the result to MGR5# and MGR5Name.

Tags (2)
4 Replies
Not applicable

Re: Creating hierarchy from simplified personnel file...

Possible to attach your sample file?

Re: Creating hierarchy from simplified personnel file...

There is a hierarchy prefix for load statements that you could use.

Regards

Marco

Re: Creating hierarchy from simplified personnel file...

See also:

Using lookup

Regards

Marco

Not applicable

Re: Creating hierarchy from simplified personnel file...

@MarcoWedel The concept you post about is amazing, but I've spent my entire Sunday attempting to modify this code to work and it just doesn't sing.  I do not get errors but I do get synthetic keys for employee and manager, and I can't seem to get a full 4 levels of management

Also, I already have my own employeeID and I can understand where AutoNumber come into play, but I cannot get my employeeIDs to be allowed into the table.

Yea, I'm new, and, I have a headache   Here's hoping you can help tweak it!

I've included in the attached file are the following tabs:

Results: What I am expecting to come close to

PersonnelFile: Limited names in current format to complete 2 samples of 4 and 5 level management

TableView: just that, a pic of my tables

ScriptExport: just that, an export of my current script

Community Browser