topic Loss Triangles in QlikView

Loss Triangles

Mon, 11 Feb 2013 22:37:06 GMT

I'm creating a chart showing loss triangles. This has the booking year (Book Yr) running across the top row, the underwriting year (UW Yr) running down the left column, and the entries being the sum of the losses. For example, we have policies that we underwrote in 2009. During 2009 some losses are booked. We find out about more losses in 2010, 2011, 2012 and 2013. So I'd like the row corresponding to UW Yr 2009 to show a running sum of those losses. The rightmost column, Book Yr=2013 should show the total of all of the losses that have been reported to us for those 2009 policies. I'm extremely new to QlikView and I can't seem to figure out how to get a running total like that to work. I did copy some suggestions on running totals, but I seem to have it accumulating in both dimensions. I have to keep the rows independent. Is this possible?

Re: Loss Triangles

kash04kk — Tue, 30 Jun 2015 06:05:37 GMT

Hey Mitchell,

What a coincidence. I'm doing a similar project.

If you want the cumulative claims to appear in UY rows then use this:

=RangeSum(Alt(Before([cumulative claims]), 0), sum(claim_amount))

where,

'cumulative claims' is the label of the expression you are using,

'claim_amount' is the amount of claims

Hope this helps. Cheers