topic Re: Excluding Selections in QlikView

Excluding Selections

Thu, 20 Nov 2014 10:48:16 GMT

Not sure the easiest way to do this but i have this formula for calculating average CSi Score, for each wave and across all leasing companies. I have a selection box for activity and i wanted this result not to be changed by selecting anything in activity field, any ideas ?

=avg({<Country= {$(vMarket)}, CSi={'>=0'}, tfs= {'>=$(vMinFleetSize)<=$(vMaxFleetSize)'}, section1Loop= {$(vLeaseCo)}, Wave={'$(vWaveCurrLC)'}, Activity= >} CSi)/100

Thanks for you help much appreciated.

Sarah

Re: Excluding Selections

anbu1984 — Thu, 20 Nov 2014 10:59:56 GMT

Activity= -- This will ignore any selection on Field Activity

Are you not getting correct result?

Re: Excluding Selections

ThornOfCrowns — Thu, 20 Nov 2014 11:01:00 GMT

You can use <[SelectionField}=,> to ignore that field.

Re: Excluding Selections

Thu, 20 Nov 2014 11:04:42 GMT

When inside set analysis you do 'Field =' it will ignore any selections in that field. For your example your code should work.

Re: Excluding Selections

Thu, 20 Nov 2014 11:36:10 GMT

didn't seem to work tried both ways am i doing something wrong ?

=min(aggr(avg({<Country= {$(vMarket)}, CSi={'>=0'}, tfs= {'>=$(vMinFleetSize)<=$(vMaxFleetSize)'}, LeaseCo= ,<[Activity]= , Wave= {'$(vWaveCurr)'} >} CSi),section1Loop))/100

Re: Excluding Selections

CELAMBARASAN — Thu, 20 Nov 2014 11:48:21 GMT

When using Aggr, you need to apply the set analysis to the outside of the expr too, like below

=min({<Country= {$(vMarket)}, CSi={'>=0'}, tfs= {'>=$(vMinFleetSize)<=$(vMaxFleetSize)'}, LeaseCo= ,[Activity]= , Wave= {'$(vWaveCurr)'} >} aggr(avg({<Country= {$(vMarket)}, CSi={'>=0'}, tfs= {'>=$(vMinFleetSize)<=$(vMaxFleetSize)'}, LeaseCo= ,[Activity]= , Wave= {'$(vWaveCurr)'} >} CSi),section1Loop))/100

Re: Excluding Selections

Thu, 20 Nov 2014 12:56:27 GMT

Thanks so much guys works perfectly !