topic Re: Simple Question on making active only hierarchy selected in QlikView

Simple Question on making active only hierarchy selected

gerrycastellino — Fri, 24 Apr 2015 00:24:43 GMT

I have several hierarchies coming into a list object displayed as tree view.

I have an expression to display the tree structure, which cannot be changed - I cannot use the PATH for some other technical reasons.

How can I just make the only visible hierarchy in my tree structure view, the hierarchy I have selected in my hierarchy name list box ?

attached is the ".qvw" and the hierarchy .qvd.

Any help appreciated !

Re: Simple Question on making active only hierarchy selected

SergeyMak — Fri, 24 Apr 2015 00:47:11 GMT

Hi Gerry,

Try Hide Excluded flag in Listbox properties

Hope it helps

Regards,

Sergey

Re: Simple Question on making active only hierarchy selected

gerrycastellino — Fri, 24 Apr 2015 00:52:45 GMT

‌cannot use hide exlcuded - due to other technical / display reasons

is there another way to accomplish this ?

Re: Simple Question on making active only hierarchy selected

SergeyMak — Fri, 24 Apr 2015 00:59:48 GMT

Yes. You can create four listboxes and show in conditionally based on what is selected in your other listbox.

For example a condition will be HIERARCHY_NAME='FPA (Dafault)'

etc.

Regards,

Sergey

P.S.: It would be good to know what technical limitation do you have.

Re: Simple Question on making active only hierarchy selected

Fri, 24 Apr 2015 02:13:52 GMT

Please see attached file. I've created two alternative list boxes one using your expression and one using the hierarchy path. When hierarchy name is selected the tree view listbox only displays the visible hierarchy. Hope this works. p.s do check whether the use of nested ifs in your expression can cause performance issues.

regards

sana

Re: Simple Question on making active only hierarchy selected

gerrycastellino — Fri, 24 Apr 2015 02:58:17 GMT

OMG ! Wow ! I think you worked it out ! I need to look at this further.

Let me know where I can send the box of chocolates

but one question: why do you have the 'if' statement repeating.

can you explain your pick(match in English syntax ...

Gerry.

Re: Simple Question on making active only hierarchy selected

gerrycastellino — Fri, 24 Apr 2015 03:00:06 GMT

HI Sergey:

My requirements are that I do not know how many hierarchies I will be importing, I needed it to be totally flexible to accomodate an unknown limit. Can't have a static number of list boxes.

Gerry.

Re: Simple Question on making active only hierarchy selected

Fri, 24 Apr 2015 03:18:19 GMT

The pick match is being used instead of multiple ifs here…..

so in this EXPRESSION:

pick(match(GetSelectedCount(HIERARCHY_NAME),0,1),

hierarchy_tree,

pick(match(HIERARCHY_NAME,GetFieldSelections(HIERARCHY_NAME)),hierarchy_tree))

THE PICK(MATCH is doing something like below:

if GetSelectedCount(HIERARCHY_NAME)=0 then the listbox returns the field hierarchy_tree

and if GetSelectedCount(HIERARCHY_NAME)=0 then it returns listbox for the expression if(HIERARCHY_NAME=GetFieldSelections(HIERARCHY_NAME),hierarchy_tree)

Re: Simple Question on making active only hierarchy selected

Fri, 24 Apr 2015 03:26:54 GMT

not very sure but if the if statement isn't repeated then the list box appears blank when nothing is selected in hierarchy_name.

so you can't use the path field instead of the expression in the list box?

Re: Simple Question on making active only hierarchy selected

gerrycastellino — Fri, 24 Apr 2015 03:54:19 GMT

ok I think I understand this.

I cannot use the hierarchy_tree, as I need some fine control over the hierarchy in being able to detect what levels

have been chosen, hierarchy_tree does not let me do that, but the if does.

Gerry.

Re: Simple Question on making active only hierarchy selected

Fri, 24 Apr 2015 04:10:41 GMT

hey check out this document:

Hierarchies

the ancestor table/ expanded nodes table mentioned here might help resolve your issue with the hierarchy_tree listbox