Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Manager Employee Drill Down

I have the below data in excel file & have a drill down challenge.

Emp ID Name Title Manager ID

1 John CEO Null

2 Smith CFO 1

3 Jane Manager 2

4 Doe Analyst 3

How do I create a drill down hierarchy in such a way that I drill from the top all the way to the bottom?

Thanks,

Dinesh.

2 Replies
johnw
Champion III
Champion III

Probably with either a hierarchy load or a semantic load, depending on what you're after. I suspect you're after a hierarchy load. I haven't used them in any actual applications, but you should be able to find more information in the help text.

Anonymous
Not applicable
Author

Dinesh,
I agree with John about hierarchy. See attached. The script for this in my example (in case you don't downlod files):


DrillDown:
HIERARCHY (EmpID, ManagerID, Name, Manager, Name,'Tree View', '/')
LOAD
EmpID,
Name,
Title,
ManagerID
RESIDENT data;
DROP TABLE data;