Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

matthewdavies
New Contributor II

Development Triangle

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

  

DayNet Paid
01201
96000
105410
11-201
12280
13-2898
16-1000
18710
24-3875
255
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?

Tags (2)
2 Replies

Re: Development Triangle

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

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

- Marcus

matthewdavies
New Contributor II

Re: Development Triangle

Thanks, works a treat.

Community Browser