topic Manager Employee Drill Down in QlikView

Manager Employee Drill Down

Anonymous — Fri, 15 Oct 2010 20:54:01 GMT

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.

Manager Employee Drill Down

johnw — Fri, 15 Oct 2010 22:55:15 GMT

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.

Manager Employee Drill Down

Anonymous — Sun, 17 Oct 2010 13:49:40 GMT

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;