How can I flag leaf nodes in a hierarchy?

Wed, 14 Sep 2011 19:34:07 GMT

Hey all. So I have a table that is a hierarchy, although I'm not loading it as a hierarchy table in QlikView. The table looks like this:

NodeId,

NodeName,

NodePath, // Delimited string including all nodes down to this one, e.g., Top\Branch\Branch\Leaf

NodeCode, // Numerical version of the above, e.g., 1.2.2.4

ParentNodeId,

RootNodeIt

So, is there a way for me to create a derived IsLeaf flag field? I'm assuming I'll have to run it through the hierarchy load first to get that. Any ideas?

Thanks,

Eric

Re: How can I flag leaf nodes in a hierarchy?

hdonald — Thu, 15 Sep 2011 06:34:59 GMT

Hi,

How about adding the parent nodes to a mapping table and flagging any child nodes that are not in that table ?,

e.g.

Map_Parents:

MAPPING LOAD ParentNodeID,

0 as NotLeaf

FROM

HTable.xlsx

(ooxml, embedded labels, table is Sheet1);

HTable:

LOAD NodeId,

NodeName,

NodePath,

NodeCode,

ParentNodeID,

RootNodeID,

ApplyMap('Map_Parents',NodeId,'1') as LeafFlag

FROM HTable.xlsx

(ooxml, embedded labels, table is Sheet1);

Use the Qlikview Hierarchy load, instead of a normal load, if you want the 'expanded' node table format - see attached,

Regards,

topic Re: How can I flag leaf nodes in a hierarchy? in QlikView

How can I flag leaf nodes in a hierarchy?

Re: How can I flag leaf nodes in a hierarchy?