Hierarchical in qlikview

[#1]

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’

[robert_mika]

Could you provide more details/data?

[Anonymous]

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

[#4]

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

[#5]

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

[ramoncova06 · Accepted solution]

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