topic Hierarchie Listbox in QlikView

Hierarchie Listbox

Thu, 03 Sep 2015 14:27:57 GMT

Hi everybody,

I just created a hierarchy and that worked fine.

Now I have two issues with that Hierarchy:

1.) I want to see in the Listbox the Hierarchie with NodeID and NodeName (01 Sales, 02 Production,...) At the Moment it shows only the NodeID

2.) When I filter on ProdMaint, I need to see Prod/Maint, 02 and 03 in the Listbox (as valid Values) At the Moment it Shows only Prod/Maint as valid and 02 and 03 gray.

How can I realise that.

Re: Hierarchie Listbox

Thu, 03 Sep 2015 14:29:05 GMT

here the screenshot to my question 2.

Re: Hierarchie Listbox

hic — Fri, 04 Sep 2015 10:14:33 GMT

If you create a Hierarchy load like

   Hierarchy (NodeID, ParentID, NodeName, ParentName, Pathsource, Path, '\', Depth)
   Load
      NodeID & ' ' & NodeName as Pathsource,
      …

you will get the path you want. Note the "Pathsource" field.

On the selections: If you make a selection of a node when it is expanded, you will select only the top node. But if you select a node when it is collapsed, you will select the entire tree. So, make the selection when the node is collapsed, and you will get what you want.

The reason why we have chosen to design it this way, is that it wouldn't be possible to select the top node only otherwise.

HIC

Re: Hierarchie Listbox

Fri, 04 Sep 2015 13:29:12 GMT

Hi Henric,

this worked very well. Thank you very much. Now that created a further question to me.

Would you please help me with that again?

I have to create two Hierarchies (called CODE D and CODE B). The Hierarchy in CODE D is now finished (thx to you again).

Now I want to create a Hierarchy of CODE B.

Problem is, that on TOP the Parent ID is the Bottom of CODE D.

(I know copied the complete Hierarchy of CODE D into CODE B).

But I wish to get a link between those two, because I dont want to have two identically databases.

o you have an idea?

Thank you very much in adcance

Chris