Set selections from a variable

[nz_chris]

Hello folks,

I am quite new to Qliksense and currently facing a problem which I unfortunately cannot handle on my own.

I want to store values from a filter pane into a variable. I have done that with getfieldseletions and it worked.

But now I want to use this values on another filter pane with alternate state.

I tried this expression {$<Field={'$(vVariable)'}>} but it did not work.

Any suggestions?

[Mathumitha]

Hi @nz_chris ,

For example,

If we need to calculate the sum of sales for the year that is getting selected, then,

sum({[StateA]}{<Year={'$(vVariable)'}>}Sales)

[nz_chris]

Hi @Mathumitha ,

thank you for your suggestion. It is not exactly what I want to do. I just want to select the fields stored in the variable.

How can I achieve this?

[nz_chris · Accepted solution]

Hello again,

I Solved it on my own. I share the solution for all facing the same problem.

When you take your values with an action via "set variable" you must not use "GetFieldSelections(Field)" cause you get a string with the values comma separated. But instead you need them semi colon separated. So you have to use "replace(GetFieldSelections(Field),',',';')"

Afterwards your can generate a new action with "select values in a field" and set the variable as value.

[Prithika]

hello,

I have question

in a dataset i have student name and their fees status

is it possible for me to use kpi to show their fees status if i selected a student name in filter pane?