topic Re: drop-down list box - what's wrong? in QlikView

drop-down list box - what's wrong?

Thu, 23 Apr 2015 12:32:56 GMT

Hello,

I have 2 levels of division my data:

general - PRODUKT eg. ror

and more specific - RODZAJ_PRODUKTU eg. kapitalne konto etc.

My script is:

HIER_PROD:
LOAD
PRODUKT,
"RODZAJ_PRODUKTU",
1 as LP,
if (isnull("RODZAJ_PRODUKTU"), PRODUKT,
PRODUKT&'/'&"RODZAJ_PRODUKTU")
as "PROD_vs_RODZ_PROD"
RESIDENT PODSUM_3;

Next I created LISTBOX from PROD_vs_RODZ_PROD,

next I marked ‘Show as TreeView with Separator -> / ’

I attached what I received.

The problem is that I can't filter on PRODUCT (general level), but only on RODZAJ_PRODUKTU (more specific level).

Eg. I can't chose all products named ror, I can only mark specific kinds of ror on the lower lewel.

Could someone help me?

Re: drop-down list box - what's wrong?

Oleg_Troyansky — Thu, 23 Apr 2015 15:32:33 GMT

In order to be able to select (and summarize) at both levels, you need to load your data using the keywords HIERARCHY and HIERARCHYBELONGSTO. Look up these terms in the manual. They create an unbalanced hierarchy that allows the kind of functionality that you are trying to implement.

cheers,

Oleg Troyansky

Re: drop-down list box - what's wrong?

MarcoWedel — Sat, 25 Apr 2015 00:00:13 GMT

Hi,

you have to add seperate field values to your new field "PROD_vs_RODZ_PROD" containing only the PRODUKT values to be able to select the PRODUKT groups.