Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

regional grouping

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.

Labels (1)
1 Reply
Not applicable
Author

Hi

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