Unselect

schumi1980 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have made a line chart of loss ratios per month based on the formulae:

sum({<AccidentYear={'2008''}>} Claims) / sum(<AccidentYear={'2008''}>} Premium) as AY 2008

sum({<AccidentYear={'2009''}>} Claims) / sum(<AccidentYear={'2009''}>} Premium) as AY 2009

sum({<AccidentYear={'2010''}>} Claims) / sum(<AccidentYear={'2010''}>} Premium) as AY 2010

sum({<AccidentYear={'2011''}>} Claims) / sum(<AccidentYear={'2011''}>} Premium) as AY 2011

sum({<AccidentYear={'2012''}>} Claims) / sum(<AccidentYear={'2011''}>} Premium) as AY 2012

sum({<AccidentYear={'2013''} >}Claims) / sum(<AccidentYear={'2012''}>} Premium) as AY 2013

sum(Claims) / sum( Premium) as Weighted Average Loss Ratio

Dimension is Accident Month. The chart shows me 7 lines.

I would now like to be able to unselect for example AY 2011 so that on the chart AY 2011 is no longer visible and the Weighted Average Loss Ratio is calculated.

However, when I unselect AccidentYear in the corresponding listbox , only the average is recalculated, the line for AY 2011 is still visible although it is based on data only from AccidentYear 2011 which I have unselected in the list box.

How can I make sure that also the Accident Year line, for example AY 2011, disappears when I unselect it in a listbox?

Many thanks.

Best regards,

Jan

Re: Unselect

sunny_talwar — Wed, 14 Feb 2018 12:54:19 GMT

Try adding * to the set analysis and see if that works

sum({<AccidentYear*={'2008''}>} Claims) / sum(<AccidentYear*={'2008''}>} Premium) as AY 2008

sum({<AccidentYear*={'2009''}>} Claims) / sum(<AccidentYear*={'2009''}>} Premium) as AY 2009

sum({<AccidentYear*={'2010''}>} Claims) / sum(<AccidentYear*={'2010''}>} Premium) as AY 2010

sum({<AccidentYear*={'2011''}>} Claims) / sum(<AccidentYear*={'2011''}>} Premium) as AY 2011

sum({<AccidentYear*={'2012''}>} Claims) / sum(<AccidentYear*={'2011''}>} Premium) as AY 2012

sum({<AccidentYear*={'2013''} >}Claims) / sum(<AccidentYear*={'2012''}>} Premium) as AY 2013

topic Re: Unselect in QlikView

Unselect

Re: Unselect