topic Re: Set selections from a variable in App Development

Set selections from a variable

nz_chris — Tue, 28 Feb 2023 08:54:24 GMT

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?

Re: Set selections from a variable

Mathumitha — Tue, 28 Feb 2023 12:24:25 GMT

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)

Re: Set selections from a variable

nz_chris — Tue, 28 Feb 2023 12:51:09 GMT

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?

Re: Set selections from a variable

nz_chris — Wed, 01 Mar 2023 12:16:21 GMT

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.

Re: Set selections from a variable

Prithika — Wed, 02 Aug 2023 05:43:27 GMT

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?