Development Triangle

Anonymous — Tue, 28 Mar 2017 15:05:55 GMT

All,

Was hoping someone would be able to help me with a pivot chart issue i am having.

Little background, I'm trying to show the "ultimate" value of the customer after they've received all their deductions to see how much is left. Basically a running total.

Data

Day	Net Paid
0	1201
9	6000
10	5410
11	-201
12	280
13	-2898
16	-1000
18	710
24	-3875
25	5
26	-109.25

The end value of the customer is 5522.75 and i am trying to show this horizontally in a pivot with a cyclical group going vertically.

using the below formula my end result is incorrect at -109.25

=rangesum(above(sum(Claim_Incurred),0,rowno()))

Does anyone have any suggestions?

Re: Development Triangle

marcus_sommer — Tue, 28 Mar 2017 17:36:54 GMT

It seems you need to adjust to the horizontal view with something like:

=rangesum(before(sum(Claim_Incurred),0,columnno()))

- Marcus

Re: Development Triangle

Anonymous — Thu, 30 Mar 2017 14:44:30 GMT

Thanks, works a treat.

topic Development Triangle in QlikView

Development Triangle

Re: Development Triangle

Re: Development Triangle