Select in Field multiple selections with parentheses

anothergreg — Wed, 25 Nov 2020 16:16:04 GMT

I need a button to select multiple values, which I understand the syntax is (value1|value2). However, my values have parentheses in them. For example:

OPTION

a) $1 - $2

b) $2 - $5

c) $5 - $10

d) $10+

If I try to place it in the syntax to select multiple values, the parenthesis in each value closes the syntax that accepts multiple values. I can't use single quotes or double quotes to contain the string. I've tried setting variables to the strings I want to use and placing the variable name into the syntax like ($(vOptionA)|$(vOptionB)) but this does not work either. I cannot modify the data.

Can anyone help me how to select in field for multiple selections if those selections have a closed parenthesis in each of them?

Re: Select in Field multiple selections with parentheses

marcus_sommer — Thu, 21 Sep 2017 14:48:04 GMT

Did you try: ("value1"|"value2") ?

- Marcus

Re: Select in Field multiple selections with parentheses

anothergreg — Thu, 21 Sep 2017 14:51:36 GMT

I had tried that but only with an = sign in front. When I pulled it out it worked fine. Thank you!

topic Re: Select in Field multiple selections with parentheses in QlikView

Select in Field multiple selections with parentheses

Re: Select in Field multiple selections with parentheses

Re: Select in Field multiple selections with parentheses