topic Re: Set Multiselection value from variable in QlikView

Set Multiselection value from variable

Wed, 23 Jan 2013 14:32:33 GMT

I have question regarding multiple selection in Qlikview 11.

How do I set multiple values in listbox from a variable?

Re: Set Multiselection value from variable

Gysbert_Wassenaar — Wed, 23 Jan 2013 14:36:12 GMT

Use a Select in Field action (on a button or text object) and use the variable as search string. Your variable needs to have the form (val1|val2|...|valn). The values need to be separated by a pipe symbol and enclosed in parentheses.

Re: Set Multiselection value from variable

Wed, 23 Jan 2013 14:48:43 GMT

Many thanks for your replay.

I have done exactly same but it not selecting values in listbox...(I mean there is no selection happen in Listbox)

for example :

vTest = British Airways|CAMP British Airways

Creted action on Button - Select in Field - (Field : Agreement) (Search String: =vTest)

Do you have any example file?

Re: Set Multiselection value from variable

Gysbert_Wassenaar — Wed, 23 Jan 2013 15:17:33 GMT

Your vTest variable is missing the surrounding paretheses. And since your values have spaces in them they need to be enclosed in double quotes:

vTest = ("British Airways"|"CAMP British Airways")

Re: Set Multiselection value from variable

Wed, 23 Jan 2013 15:38:53 GMT

Yeh! it is working fine....

thanks

Re: Set Multiselection value from variable

mbandham — Wed, 20 Apr 2022 12:29:05 GMT

@Gysbert_Wassenaar Hi, In my case, the value in my variable looks like this.

"(British Airways|CAMP British Airways)"

Is there any way, I make it work.?

Re: Set Multiselection value from variable

marcus_sommer — Wed, 20 Apr 2022 12:53:32 GMT

Each search-string which contains a space or a special chars needs to be wrapped with double-quotes. Just take a closely look on the example above.

- Marcus