How to pass multiple user selected values to a variable

[venkateshr123]

Hi All,

Im new to QlikView.

Im using GetFieldSelections(country) to pass user selected values to a variable and same variable is used in multiple data tables like Aging 0 to 30 days, 31 to 60 days, etc. in a tab for filtering data. Its working fine if user selects 1 value like US. when they selects multiple values like US, UK, FRANCE, etc. its not passing the selections to other data tables.

Any suggestion.

Thanks,

Venkatesh

[lironbaram]

Hi, 
my first question will be why do you need to pass selections via Variable.
If the user makes selections it automatically filter the data in the app to those countries. 
no need to do anything.

[venkateshr123]

Hi, It was designed by my predecessor where if I click on any button, it clears all selection in "Multi Select" box and tries to reload the Pre-set criteria through Actions "Select in Field" values.  This is where I would like to pass country, services, line of business, etc. selection to variable so that, when its reloading the pre-set criteria, it can also load user selected countries. 

Hope this helps to help me. 

[lironbaram]

IF you want to pass multiple values for field selection 

then you need to send this type of string 
(value1|value2)
so in your case, you can use this expression

= '(' & Concat({state1} distinct Country,'|') & ')'

[venkateshr123]

Thanks, Let me try with this.