topic regional grouping in QlikView

regional grouping

Wed, 20 Jan 2010 10:34:00 GMT

Hi,

I have a table set up as follows:

Identifier|Country Code|Regional group 1|Regional Group 2|Regional group 3

Countries may belong to one or more regional groups.

I would like to create a list box with all the countries and regional groupings.

I had thought to create this using sets but apparently list boxes do not accept sets in the expression.

any suggestions?

Thanks for any advice.

regional grouping

Wed, 20 Jan 2010 13:26:06 GMT

Since the countries and regions are stored in separate fields there is no way of displaying them together in a listbox.
One easy solution, if you use QV9, is to add a Search object and select both Country and all the Regional fields.
That way you can search in all of those fields at the same time.
If it's really needed to display them in a listbox you need to do some scripting to concatenate the country and region fields into one.

/Fredrik