Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Assign multiple values to a select in field action


Hi,

  In the "Select in Field" action, how do you assign multiple values to a field?

  I want to assign two values t be selected by default once a user click a button.

attached is a screenshot.

  Many thanks!

1 Solution

Accepted Solutions
JonnyPoole
Former Employee
Former Employee

Here is the syntax for multiple values , including scenarios when there are space:

ex:  ("North America"|"South America")

View solution in original post

5 Replies
JonnyPoole
Former Employee
Former Employee

Here is the syntax for multiple values , including scenarios when there are space:

ex:  ("North America"|"South America")

Anonymous
Not applicable
Author

Many thanks Jonathan!!!!

Not applicable
Author

Is there a way to use this in an if statement, too?

I would like to use the expression like this:

=if(FieldA = 'somevalue', ("North America"|"South America"))

The above won't work.

Thanks

Jens

jzimolong
Creator II
Creator II

In attached, I setup two variables, then had the select in field button read one of them to produce result.  First variable (vAuto) gets a field selection, and the second variable (vSelectInField) does the if statement.

Open app, select "Toyota" in Auto field, then click button and it will further filter down to just 2 names.

Not applicable
Author

Aaaah, only thing I have to change is the ' ' around my expression.

=if(FieldA = 'somevalue', '("North America"|"South America")' )



Thanks a lot!