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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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