Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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
Employee
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
Employee
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!