Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Oleg_Troyansky

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

MarcoWedel

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