topic Hierarchical in qlikview in QlikView

Hierarchical in qlikview

Thu, 28 May 2015 12:04:46 GMT

how to bring Hierarchical from SAP to Qlikview not as flat table

I have table ‘PA0001‘ filed ‘ORGEH’ to Map with table ‘HRP1001’ filed ‘SOBID’

Re: Hierarchical in qlikview

robert_mika — Thu, 28 May 2015 12:33:07 GMT

Could you provide more details/data?

Re: Hierarchical in qlikview

Anonymous — Thu, 28 May 2015 12:46:51 GMT

ya Robert said pls send the details of your questions? This is not clear.

Re: Hierarchical in qlikview

Thu, 28 May 2015 13:26:42 GMT

how to achieve Organizational Hierarchy to find the employee count. There is a table HRP1001 which has the parent & child information. A child itself can be also a parent.

Parent filed 'HRP1001.OBJID '

chiled Filed 'HRP1001.SOBID '

mapping with PA0001.ORGAH

I want to count in all the level from Top to button

Re: Hierarchical in qlikview

Thu, 28 May 2015 13:26:49 GMT

how to achieve Organizational Hierarchy to find the employee count. There is a table HRP1001 which has the parent & child information. A child itself can be also a parent.

Parent filed 'HRP1001.OBJID '

chiled Filed 'HRP1001.SOBID '

mapping with PA0001.ORGAH

I want to count in all the level from Top to button

Re: Hierarchical in qlikview

ramoncova06 — Thu, 28 May 2015 13:33:59 GMT

have you tried with Hierarchy function?

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

where

NodeID is the name of the field that contains the node id. This field must exist in the input table.

ParentID is the name of the field that contains the node id of the parent node. This field must exist in the input table.

NodeName is the name of the field that contains the name of the node. This field must exist in the input table.

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