Gauge Chart Help

Mon, 13 Apr 2015 15:09:59 GMT

Just wondering if anybody can offer me some advice on a Gauge Chart to put on my main dashboard page.

I am looking to use a gauge to show the loss ratio % comparing 2011 to 2010. I have the loss ratio worked out per month in a bar chart but i dont have a clue how to compare yearly in a gauge chart.

I am not sure if this is possible but if anyone could help it would be greatly appreciated.

Re: Gauge Chart Help

Anonymous — Mon, 13 Apr 2015 17:06:44 GMT

to compare the loss ratio year over year, here is the expression:

(Sum ({<Type={'Claims'}, [Posting Year]={'$(vMaxYear)'}>} Amount)/Sum ({<Type={'Income'}, [Posting Year]={'$(vMaxYear)'}>}Amount))
/(Sum ({<Type={'Claims'}, [Posting Year]={'$(vPrevYear)'}>} Amount)/Sum ({<Type={'Income'}, [Posting Year]={'$(vPrevYear)'}>}Amount)))
-1

where vMaxYear = max([Posting Year]

and vPrevYear = $(vMaxYear)-1

In your case, YoY comparison for loss ratio is just 1% for 2012 and 2011. you may want to rethink the use of a gauge chart and show something else...a bullet chart or modified bar chart.

topic Gauge Chart Help in QlikView

Gauge Chart Help

Re: Gauge Chart Help