Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III

Cumulative Sum by Field Values

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

 

snapshot.PNG

1 Solution

Accepted Solutions
rubenmarin

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

View solution in original post

3 Replies
rubenmarin

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

MalcolmCICWF
Creator III
Creator III
Author

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

MalcolmCICWF
Creator III
Creator III
Author

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

Capture1.PNG