QlikSense - Use getselection in expression

[Anonymous]

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

[vinieme12]

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??

[girirajsinh]

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