Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Hierarchical in qlikview

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’

1 Solution

Accepted Solutions
ramoncova06
Valued Contributor III

Re: Hierarchical in qlikview

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

5 Replies

Re: Hierarchical in qlikview

Could you provide more details/data?

rank_nandha
Contributor II

Re: Hierarchical in qlikview

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

Not applicable

Re: Hierarchical in qlikview

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

Not applicable

Re: Hierarchical in qlikview

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
Valued Contributor III

Re: Hierarchical in qlikview

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

Community Browser