topic Hierachy with Tree in QlikView

Hierachy with Tree

carolin01 — Fri, 30 May 2014 10:49:30 GMT

Hi, I would like to create a hierachy load and use the tree function in a list box. Therefore I´ve created the following load statement:

HIERARCHY (NodeCountryID, ParentCountryID, NodeCountry, Tree, '/')
Load*;

LOAD NodeCountryID,
     ParentCountryID,
     NodeCountry,
     NodeCountryDesc
FROM

(ooxml, embedded labels, table is Sheet2);

Qlik View creates two fields: Tree and Path. Path is empty and Tree just shows the 1st level - see below:

What is wrong here? Any suggestions?

Many thanks in advance.

Best regards

Carlin

Re: Hierachy with Tree

tresB — Fri, 30 May 2014 11:01:09 GMT

Try like:

HIERARCHY (NodeCountryID, ParentCountryID, NodeCountry,NodeCountryDesc, Tree, '/')

Re: Hierachy with Tree

PrashantSangle — Fri, 30 May 2014 11:19:34 GMT

Hi,

Check this example.

This might help you.

Regards,

Re: Hierachy with Tree

carolin01 — Fri, 30 May 2014 11:38:51 GMT

OK, that was closed. I adjusted now to:

HIERARCHY (NodeCountryID, ParentCountryID, NodeCountry,, NodeCountryDesc, Tree, '/')
Load*;

LOAD NodeCountryID,
     ParentCountryID,
     NodeCountry,
     NodeCountryDesc
FROM

(ooxml, embedded labels, table is Sheet2);

and got the following result:

But I would like to have:

EMEA --> Bulgaria etc.

CNTW --> China etc.

I know only see the third level but not the naming of the 2nd and 1st level... Any ideas what I´m still doing wrong?

Re: Hierachy with Tree

gilbertomedeiro — Tue, 13 Sep 2016 21:40:58 GMT

Hi Carolin,

Sorry, maybe is too late to reply about that, but at least to me, every question or doubt needs response! For this reason, I reproduced a small and simple code that can be helpful.

Regards

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

Hierarchy:

Hierarchy(NodeID,ParentID, NodeName, ParentName,Tree,Path)

Load*;

LOAD * inline [NodeID, ParentID, NodeName ,Tree

1,1,'EMEA ','EMEA '

2,1,'EMEA','Bulgaria'

3,3,'CNTW ', 'CNTW '

4,3,'CNTW', 'China'

5,1,'EMEA', 'Dinamarca'

];