Grouping List box values

[Anonymous]

Hi,

I have a list box having values like 00,01,02,03,04,05,06,07,08,09,10,11 .I want my list box like Gro1,Gro2 and Others.In this Gro1 is combination of 00,01,02 and Gro2 is combination of 03,04,05 and remaining are in Others.If I select Gro1 the selection is combination of 00,01,02 .

Please help me to solve this.

Thanks in advance

Best Regards

Anusha

[petter]

You can use a listbox an combine several fields with a separator. Then use select "Show as Treeview" in the listbox dialog with the same separator chosen.

You will then get a hierarchy that is the grouping you need.

Use QlikView Help and search for Treeview and you will get a full explanation.

[#3]

Hi Anusha,

you can create a grouping field for this, each group will link to a set list of underlying values, so selecting on a group will select a subset of the values.

see attached

hope that helps

Joe

[maxgro · Accepted solution]

a listbox with expression

=pick(wildmatch(YourField, 00,01,02,03,04,05,06,'*'),

'Gro1', 'Gro1', 'Gro1','Gro2','Gro2','Gro2','Other')

[Anonymous]

Thankyou Very much Massimo Grossi