Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator III
Creator III

Select in field action with several values

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'

Peony_0-1646826527208.png

 

 

1 Solution

Accepted Solutions
Or
MVP
MVP

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.

 

View solution in original post

2 Replies
Or
MVP
MVP

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.

 

Peony
Creator III
Creator III
Author

Brilliant! It works for me! Thank you much!