non-standard search or no pattern search or no filter search or ad hoc filter search

[#1]

I have a very basic question about QlikView

I have 1000 rows with two columns

city | population of city

I have a table in my QV document with city and population. I also have a list box for cities to narrow down my resutls.

Example:

City | Population

A 1001

B 2000

C 3000

D 4000

E 5000

Use case # 1

I want to see population of only 3 (A, D, E) cities in my table and there is no character patter that I can put in my search box in cities list box that can give me the desired result. Only option for me is to do search 3 times.

Is there any option in QV where i can put a comma separated text in the search box and expect the desired result?

Thanks in advance.

[#2]

Doesn't look that way.

But if you have a 1000 rows and you need to select just three, wouldn't it be better to divide the rows in other categories, so you don't have to select from 1000 rows, but just from 50 rows (for instance)?

I can imagine you could add a column that has the state of the city, or a size category.

[#3]

Not through the standard operations.

But you can achieve through alternate solutions using SETS & MACRO but this will fails the QlikView quotes "Power of Simplicity".

Regards

Rajesh

[rwunderlich]

You can use the search expression:

=match(City, 'A', 'D', 'E')

-Rob