topic Multi select from List Box in QlikView

Multi select from List Box

jduenyas — Tue, 17 Dec 2013 22:55:33 GMT

Hi all

I have a list of many zip codes which I need to select from a List Box containing all of US zip codes.

Aside of clicking each value while holding the CTRL key, is there a way to enter (using key board or pasting a list) into the search line for the list box to select multiple items? Is there a delimiter that the list box recognizes when keying the different values?

Thanks

Josh

Re: Multi select from List Box

Tue, 17 Dec 2013 23:17:55 GMT

Ive used advanced search using expressions to do something similar to this.

Right click in the list box and goto advanced search. in the expression, put something like

=MATCH([FIELD NAME GOES HERE],'ZipCode1','ZipCode2','ZipCode3',...etc)

Then press GO. Make sure to copy your formula before pressing GO if you want to re use it. If the list is long, I use Excel to generate the list in the proper syntax and paste it into the expression.

EDIT - Actually, i just tested and you can type this formula directly into the search line and it will also work

Re: Multi select from List Box

jduenyas — Tue, 17 Dec 2013 23:29:12 GMT

Wonderful!

That worked.

Thank you