topic "Select in Field" Action -> Multiple Select in QlikView

"Select in Field" Action -> Multiple Select

Tue, 11 May 2010 09:43:49 GMT

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

"Select in Field" Action -> Multiple Select

Tue, 11 May 2010 09:47:32 GMT

hi,

use (A|*B)

this should work

thanks

"Select in Field" Action -> Multiple Select

Tue, 11 May 2010 09:55:54 GMT

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

"Select in Field" Action -> Multiple Select

Anonymous — Tue, 11 May 2010 10:12:56 GMT

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.

"Select in Field" Action -> Multiple Select

Tue, 11 May 2010 10:17:57 GMT

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

"Select in Field" Action -> Multiple Select

Tue, 11 May 2010 10:28:17 GMT

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

Re: "Select in Field" Action -> Multiple Select

Tue, 21 Aug 2012 11:37:15 GMT

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