Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

cumulative sum

Hi,

i want to do a cumulative sum by month but i don't know how to do this,

i try the rangesum function but it dont work...

Sans titre.jpg

The CA field is this expression : Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant)/1000

How can i do this? Thanks a lot !!

10 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

You need a total in Above as well and 0 as the starting index to include the current row in the cumulative value:

=Rangesum(Above(Total Sum({$<[LVR.Date d_expédition] = {">=$(vStartDate)<=$(vEndDate)"}>} LVR.Montant), 0, rowno(Total))) / 1000

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein