How to select multiple values in a field with actions ?

[#1]

Hi,

I'm trying to do something which seems very simple : I'm trying to select two or more values in a field. But I want to do this using actions (not Ctrl + Mouse button).

By example, suppose a Field 'MyField' such as :

LOAD * INLINE [
MyField
A
B
C
D
E
F
];

I just want to create an action which select B and E value. What is the correct syntax ?

Best regards

P.S : I'm working with QlikView 9 SR4 and SR5

[#2]

Excellent Answer!

[#3]

Excellent Answer!

[Anonymous]

Hi Anton

How do I add the double inverted commas dynamically.  I've tried this expression, but does not work.

='(' & Chr(34) & Replace(myVariable,',', Chr(34) & '|' & Chr(34) ) & Chr(34) & ')' 

Kind regards

Nayan

[Anonymous]

If there are spaces in between  field values,try below expression

in my case I wanted to select values like 'Level 0' ,'Level 1' ,'Level 2' from Level field ,

so if you want to select multiple values say Level 0 and Level 1 your o/p should be shown like this

("Level 0"|"Level 1")

to show o/p like use below expression

='('&'"'&Concat(distinct Level,'"|"')&'"'&')'

You can apply above expression as per your requirement ,and this will work smoothly.