topic Select in field action with several values in QlikView

Select in field action with several values

Peony — Wed, 09 Mar 2022 11:52:09 GMT

Hi all.

Please help me to create proper string with values that I need to select in field. I set several location names and separate them with comma s and apostrophes , but selection doesn't works.
Here these values:
'Arizona Avenue', 'Paula's New Avenue', 'High Road Center'

Re: Select in field action with several values

Or — Wed, 09 Mar 2022 12:03:44 GMT

Try instead e.g.

='(Arizona Avenue|Paula''s New Avenue|High Road Center)'

Note that your middle value will be tricky due to the use of a single quote within the text, so it needs to be replaced with two single quotes or otherwise dealt with.

Re: Select in field action with several values

Peony — Wed, 09 Mar 2022 12:24:56 GMT

Brilliant! It works for me! Thank you much!