Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

drop-down list box - what's wrong?

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?

2 Replies

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

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?

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.

See also:

Tree View list box

Tree List box issue

Tree View Hierarchy - select entire group?

Problem in creating ListBox showing Hierarchy (TreeView )

create a list box as TreeView having only complete dinamic path of a document

hope this helps

regards

Marco

Community Browser