topic Entering multiple selections in a list box in QlikView

Entering multiple selections in a list box

Tue, 06 Oct 2015 18:44:03 GMT

Hi everyone,

Here’s my scenario:

I have a list box that has the identification number for our partners.
I have a user that wants to select about 12 of these partners without scrolling through the list and holding down the Control
key and selecting each one.

My question: How do I allow the user to type in the identification numbers for all 12 of the partners they want to see information for?

I’ve tried using the Match() function in the Advanced Search of the list box, but that is not a viable solution for a user.

Any suggestions would be appreciated.

Thanks!

Scott

cjohnson — Wed, 07 Oct 2015 03:15:11 GMT

Hi Scott,

Try the following format when searching in the list box:

(search1|search2|search3)

Example:

Remember to remove the wildcards (*) if they exist.

If you type this in a search it should work.

Thanks,

Camile

vikasmahajan — Wed, 07 Oct 2015 04:32:55 GMT

Vikas

Wed, 07 Oct 2015 05:00:41 GMT

Use a Select -> Select in Field button action.

Type in your field name and as search string whatever you want to select for example: (selection1|Selection2) the search string needs the ()

Wed, 07 Oct 2015 17:01:05 GMT

Thanks, Camile! That worked!

I also discovered a couple things regarding selecting from a list box that I thought I’d pass on.

Suppose you want to select 2 customers from the List Box for “Company Name”

When you want to search for a string with >1 word like, “A Company’s Name”, you should enclose the entire string in
double quotes:

Ex. (“A Company’s Name”|”Another Company’s Name”)

If however, you don’t know the full string you’re searching for, you can use wildcards:

Ex. (“A Company’s *”|”Another Company’s *”)

Hope this helps others.

Thanks again!

Scott