topic Re: How to get Roll Over Employees ,Supervisor values in Single Column in QlikView

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

Tue, 16 Oct 2012 20:04:55 GMT

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

---------

If anyone can give some guidance, will really appreciate !! Thanks for the time.

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

Tue, 16 Oct 2012 20:54:47 GMT

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

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

MayilVahanan — Tue, 16 Oct 2012 21:20:02 GMT

Are you ask like this:

if no, please say your requirement in detail??

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

Tue, 16 Oct 2012 23:58:44 GMT

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.

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

CELAMBARASAN — Wed, 17 Oct 2012 13:17:02 GMT

Hi,

Did you checked with Hierarchy and Herarchybelongsto?

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

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

Wed, 17 Oct 2012 13:19:58 GMT

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$];

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

Thu, 18 Oct 2012 23:16:15 GMT

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