Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
anothergreg
New Contributor III

Select in Field multiple selections with parentheses

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?

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Select in Field multiple selections with parentheses

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

- Marcus

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Select in Field multiple selections with parentheses

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

- Marcus

View solution in original post

anothergreg
New Contributor III

Re: Select in Field multiple selections with parentheses

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