Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
crystles
Partner - Creator III
Partner - Creator III

Select Field Trigger - multiple options in field

I need to filter the Document in the Trigger for "On Open"

I can do that with just one selection, but I cant figure out the syntax for multiple choices?

I have tried

  • 'Section1' and 'Selection2'
  • 'Section1' or 'Selection2'
  • 'Section1' ,'Selection2'

But none of them work?

1 Solution

Accepted Solutions
crystles
Partner - Creator III
Partner - Creator III
Author

I found this article that explained it.  Example of Selecting Multiple Field Values

I had to add double quotes around the selections instead of single quotes.

("CANADA" | "UNITED STATES")

Then the formula worked.

View solution in original post

3 Replies
m_woolf
Master II
Master II

(Selection1|Selection2)

MK_QSL
MVP
MVP

('A'|'B'|'C')

this will give you A and B and C selection

crystles
Partner - Creator III
Partner - Creator III
Author

I found this article that explained it.  Example of Selecting Multiple Field Values

I had to add double quotes around the selections instead of single quotes.

("CANADA" | "UNITED STATES")

Then the formula worked.