topic Grouping List box values in QlikView

Grouping List box values

Anonymous — Wed, 06 May 2015 11:02:36 GMT

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

Re: Grouping List box values

petter — Wed, 06 May 2015 11:05:53 GMT

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.

Re: Grouping List box values

Wed, 06 May 2015 11:13:13 GMT

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

Re: Grouping List box values

maxgro — Wed, 06 May 2015 11:18:08 GMT

a listbox with expression

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

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

Re: Grouping List box values

Anonymous — Wed, 06 May 2015 11:47:26 GMT

Thankyou Very much Massimo Grossi