drop-down list box - what's wrong?

[#1]

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?

[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