Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have table having the Employee , Supervisor info.
I need to get the list of all employees in organization who roll to supervisor A. Need it as single Column
For Eg.
Emp 1 , Emp 2 , Emp 3 reports to A
Emp 11 , EMP 12 reports to Emp 1
Emp 111 , Emp 112 report to Emp 11
Needed a 'Single' column with values as
Emp111
Emp112
Emp 11
Emp 12
Emp 1
Emp 2
Emp 3
A
---------
If anyone can give some guidance, will really appreciate !! Thanks for the time.
Thanks for your response & help.
Yes the solution on this problem was creating hierarchy for all supervisor. Next tricky part was to filter the dynamic generated column ( hierarchy level) and it worked !!
Anyone in Qlikview community can please assisst in above ? Just need ideas....
Hi
Are you ask like this:
if no, please say your requirement in detail??
Thank You for response.
Requirement is I need hierachy for only one supervisor.
In you example, imagine to have other supervisors , but the data is required for 'A' and its reporting chain.
Let me know if its still not clear.
Hi,
Did you checked with Hierarchy and Herarchybelongsto?
Hierarchy (NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])(loadstatement | selectstatement)
Hierarchy (NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth]) (loadstatement | selectstatement)
NodeID is the name of the field that contains the node id.
ParentID is the name of the field that contains the node id of the parent node.
NodeName is the name of the field that contains the name of the node.
ParentName is a string used to name the new ParentName field. If omitted, this field will not be created.
PathSource is the name of the field that contains the name of the node used to build the node path. Optional parameter. If omitted, NodeName will be used.
PathName is a string used to name the new Path field, which contains the path from the root to the node. Optional parameter. If omitted, this field will not be created.
PathDelimiter is a string used as delimiter in the new Path field. Optional parameter. If omitted, ‘/’ will be used.
Depth is a string used to name the new Depth field, which contains the depth of the node in the hierarchy. Optional parameter. If omitted, this field will not be created.
Hierarchy(NodeID, ParentID, NodeName) Load
NodeID,
ParentID,
NodeName,
Attribute
From data.xls (biff, embedded labels, table is [Sheet1$];
Thanks for your response & help.
Yes the solution on this problem was creating hierarchy for all supervisor. Next tricky part was to filter the dynamic generated column ( hierarchy level) and it worked !!