topic Assign Values in Variable to Field in QlikView

Assign Values in Variable to Field

Thu, 27 Feb 2014 22:23:30 GMT

Is there a way to use the values in a variable to always set the values selected in a field?

For example:

If vName = "Florida"|"New York"

Then need the State field values to be selected on Florida and New York.

When the variable changes, so would the State field selections.

Thank you much!

Anonymous — Fri, 28 Feb 2014 14:26:58 GMT

Richard,

This action will do the job:

Action - Select

Field - State

Search String - ='('&vName&')'

If you assign this action to the Variable trigger OnInput, it will work as requested.

Regards,

Michael