How to get Roll Over Employees ,Supervisor values in Single Column

[#1]

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.

[#2]

Anyone in Qlikview community can please assisst in above ?  Just need ideas....

[MayilVahanan]

Hi

Are you ask like this:

if no, please say your requirement in detail??

[#4]

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.

[CELAMBARASAN]

Hi,

Did you checked with Hierarchy and Herarchybelongsto?

Hierarchy (NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])(loadstatement | selectstatement)

[#6]

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.

Example:

Hierarchy(NodeID, ParentID, NodeName) Load

NodeID,

ParentID,

NodeName,

Attribute

From data.xls (biff, embedded labels, table is [Sheet1$];

[#7 · Accepted solution]

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 !!