question on unbalanced hierarchy

gerrycastellino — Wed, 10 Dec 2014 02:29:48 GMT

I have a hierarchy that is unbalanced.

So I could have in my hierachy leaf nodes anywhere from level 2 to level 6.

Now I need to join NodeName in my hierarchy structure to another table, but only display in a pivot chart up to the relevant leaf level.

How can I build a dynamic dimension list that knows how to display a leaf at the right level and not beyond that.

##############################################################

Hierarchy(NodeId, ParentId, NodeName, , ,NodePath,|, NodeDepth)

LOAD

Node as NodeId,

Parent as ParentId,

NodeName as NodeName,

NodeName as REP_SUB_BS_ITEM,

IS_LEAF,

PRIORITY

FROM

;

##############################################################

topic question on unbalanced hierarchy in QlikView