"Select in Field" Action -> Multiple Select

[#1]

Hello all,

a simple question (hopefully):

On a "Select in Field" Action I want to select 2 entries of a field, "A" and "This is B".

In the Help file it is documented to use the (A|B) syntax for that case.
It works perfectly if the entries do not have blanks, like (A|B) ... but I do not figure out how to make it work for entries with blanks, like (A|This is B).

I tried
(A|This is B)
(A|[This is B])
(A|'This is B')
(A|"This is B")
(A|{This is B})

*sigh* Which 'obvious' option did I forget?
Thilo

[#2]

hi,

use (A|*B)

this should work

thanks

[#3]

Hello,

thank you, it works partially.

The syntax (A|*B) selects "A", "This is B" and "This is not B".

I really just want the 2 exactly defined values.

Any additional idea?
Thanks in advance,
Thilo

[Anonymous]

That was a tricky one. Couldn't figure it out.

A workaround however:
Use 2 tasks, first one Select in Field where you select A. Then one Toggle Select where you select This is B.

Seems to work when I test it but not quite as elegant. Especially if you want to concatenate a list of values to select.

[#5 · Accepted solution]

Didnt try, but maby (A|This?Is?B)

[#6]

Hello,

yes the (A|This?is?B) syntax works!
And in my data it is unlikely that I will have entries where the ? are matched with other than blanks.

Great - thank you,
Thilo

[#7]

I don't know which version of Qlikview you are using, but I was told that the syntax

(A|"This is B") works. I just tried it myself, and for me it works perfectly...

I'm using version 11 64bit