topic Re: Assign multiple values to a select in field action in QlikView

Assign multiple values to a select in field action

Anonymous — Tue, 28 Oct 2014 02:58:54 GMT

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!

Re: Assign multiple values to a select in field action

JonnyPoole — Tue, 28 Oct 2014 03:07:17 GMT

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

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

Re: Assign multiple values to a select in field action

Anonymous — Tue, 28 Oct 2014 03:21:22 GMT

Many thanks Jonathan!!!!

Re: Assign multiple values to a select in field action

Wed, 14 Jan 2015 10:22:39 GMT

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

Re: Assign multiple values to a select in field action

jzimolong — Wed, 14 Jan 2015 10:47:19 GMT

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.

Re: Assign multiple values to a select in field action

Wed, 14 Jan 2015 11:29:09 GMT

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

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

Thanks a lot!