Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Rolling value but not

Hi,
I am looking to do something similar to the accumulation function. But instead of it calculating each row in turn and then adding it on, I would like it add up the total of each column and then calculate the ratio between amount and the paid.
What Full accumulation gives me
MonthAmountPaidRatio
Jan101000.1
Feb01000.1
Mar1002000.6
Expected result
MonthAmountPaidRatio
Jan101000.1
Feb01000.05
Mar1002000.275
Thanks in advance
1 Reply

Re: Rolling value but not

See attached example.

In case you only have personal edition:

Dimension: Month

Expression 1: sum(Amount)

Expression 2: sum(Paid)

Expression 3: RangeSum(above(Amount, 0, FieldValueCount('Month')))/RangeSum(above(Paid, 0, FieldValueCount('Month')))

Community Browser