topic Re: QlikSense - Use getselection in expression in App Development

QlikSense - Use getselection in expression

Anonymous — Sat, 16 Nov 2024 10:09:01 GMT

Is it possible to add an expression like this;

(Sum({$<Filter={'NONE SEN'}>}[vY8-Pu2])-Sum({$<Filter={'SEN'}>}[vY8-Pu2]))/Count(distinct Key)

Replace the words in red to point at a selection in a filter pane.

Any help appreciated.

Thanks

Chris

Re: QlikSense - Use getselection in expression

sunny_talwar — Fri, 13 Jan 2017 15:55:17 GMT

In filter field or another field?

Re: QlikSense - Use getselection in expression

Anonymous — Fri, 13 Jan 2017 15:59:46 GMT

In Filter Field

Re: QlikSense - Use getselection in expression

sunny_talwar — Fri, 13 Jan 2017 16:00:36 GMT

So if you want them to be not static and based on selection, why even have set analysis? not sure I understand what your end goal is

Re: QlikSense - Use getselection in expression

Anonymous — Fri, 13 Jan 2017 16:04:58 GMT

To be able to change an expression calculation based on a selection.

This stops having to duplicate expressions and altering them by using what I think might work getselection.

Re: QlikSense - Use getselection in expression

sunny_talwar — Fri, 13 Jan 2017 16:07:37 GMT

Yet again I am not clear what you want,

but this,

Sum({$<Filter={'NONE SEN'}>}[vY8-Pu2])

won't change on selections.

but this will

Sum([vY8-Pu2])

Now I am not sure why you need GetFieldSelection here? Unless there is something I need to know, I think the 2nd expression above should work

Re: QlikSense - Use getselection in expression

girirajsinh — Fri, 13 Jan 2017 16:30:33 GMT

Hi Chris,

I try to guess what you are looking for.

Please give a try with following expression and see , is that something you are looking for ? I meant check if that gives your desired result ?

Sum({1-$}[vY8-Pu2])/Count(distinct Key)

That will simply Sum ( All Non selected) - Sum( all selected based on Filter pane ) / count ( distinct key)

Re: QlikSense - Use getselection in expression

Anonymous — Sun, 15 Jan 2017 17:07:19 GMT

Hi,

I think I have got my self confused.

Basically I am looking at replacing field names with selections in an expression

For example (Sum(GetFieldSelections(PU,',',1))-Sum([Y8-Pu2]))/Count(distinct Key)

What I am not clear on is can I specify which selection to use in the field. For example can I use the first 2 selections from the same field, one for the first part of the expression and the second in the same expression.

Hope this makes a bit more sense.

Thanks for the help.

Chris

Re: QlikSense - Use getselection in expression

vinieme12 — Sun, 15 Jan 2017 17:28:20 GMT

Store your selections in variables and use variables in set analysis

You can store the values, but NOT in the order they were selected; so you cannot make out which was selected first; leave out first two!

So your best bet is to create two list boxes for both filters.

vFilter1 = GetfieldSelections(YourField1);

vFilter2 = GetfieldSelections(YourField2);

(Sum({$<Filter={"$(vFilter1)"}>}[vY8-Pu2])-Sum({$<Filter={"$(vFilter2)"}>}[vY8-Pu2]))/Count(distinct Key)

Re: QlikSense - Use getselection in expression

girirajsinh — Sun, 15 Jan 2017 17:37:58 GMT

in case you want to separate two selected value from one field

you may try

SubField(GetFieldSelections(Field),',',1).

SubField(GetFieldSelections(Field),',',2).

with assumptions that,

1. Field contails only 2 values Or will max two values can be selected.

2. Order of values selecte is not taken in to account . You can see that yourself that getfieldselections would return in one sort order.

Re: QlikSense - Use getselection in expression

vinieme12 — Sun, 15 Jan 2017 17:46:11 GMT

1st Assumption] ?

If the field has only two values! wouldn't it be easier to place them directly in the set analysis rather than forcing the user to select the values to evaluate?

2nd]?

We both agree order on selection is not taken into account, so how can we be so sure that Subfield 1 value needs to be placed in the first expression not the second??

Re: QlikSense - Use getselection in expression

girirajsinh — Sun, 15 Jan 2017 17:54:37 GMT

1st

yes it matters in only Max 2 selections...so lets drop only 2 value assumption

2nd

yes you can not make out which one to use in which order.

yes its not final solution , I suggested those just to give him some direction in how he can separate two values from selected values. It's now upto him how he intends to take it further