topic Re: Cumulative Sum by Field Values in QlikView

Cumulative Sum by Field Values

MalcolmCICWF — Sat, 16 Nov 2024 17:49:47 GMT

In my below example I am able to create incremental % by each PoolPlusId and by number of months, this expression is sum(PaymentAmount)/sum(FaceValue)

My cumulative is working but actually doing cumulative across PoolplusID. Cumulative should start over at the .01% for Month 0 of DELQ 1218, then add the cumulative as it goes up through the next PoolPlusId. This is what I'm using now... maybe I can modify? RangeSum(Above(TOTAL sum(PaymentAmount)/sum(FaceValue), 0, RowNo(TOTAL)))

Re: Cumulative Sum by Field Values

rubenmarin — Sat, 14 Nov 2020 09:02:49 GMT

Hi @MalcolmCICWF, maybe using "months+1" instead of "RowNo(TOTAL)", at least on the table this may work.

Re: Cumulative Sum by Field Values

MalcolmCICWF — Mon, 16 Nov 2020 20:25:04 GMT

Jesus, that was simple... Didn't know it was that easy. Thanks!

Re: Cumulative Sum by Field Values

MalcolmCICWF — Fri, 04 Dec 2020 17:56:57 GMT

Hey so I noticed in the 1st month, it isn't summing the first percent, it looks to be starting at row 2. I'm trying to adjust the row but cannot... ideas?

RangeSum(Above(TOTAL sum(PaymentAmount)/sum(FaceValue),0, months+1))