Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Nicole-Smith

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')))