Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a single column of reporting manager names (with other associated information).
What I need to be able to do is create a structure which creates a hierarchy within the managment column. The column contains the name of the manager that each resource reports into.
Mrs. One LevelDown
Based on this data I believe I need something that looks like this which will enable me to select a Manager name and see the staff that report into them:
Level | Name
1 Mr. Top
2 Mr. OneLevelDown
2 Mrs. OneLevelDown
Is this possible? If so how do I do this?
Is there a better solution?
This needs to be dynamic as the list will change on a monthly basis.
Go to Solution.
If you have one record per person and two columns: ID and ManagerID, then you can use the Hierarchy prefix.
View solution in original post
I do have one record per person, so this sounds like the way to approach the problem.
I will have a dig around the community for a sample file / tutorial info.
There is some info in the QlikView help. You can also load the attached file with
NodeName as District,
FROM Winedistricts.xls (biff, embedded labels, table is Sheet1$);
and see how it works.