Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Excellent Answer!
Excellent Answer!
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
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.