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: 
siddharthsoam
Partner - Creator II
Partner - Creator II

Calculate cumilative sum for date

Hi,

I want to calc cumilative  sum of sales , mentioned as desired output in the below table

 DateSalesDesired Output
Min Date11/25/20185050
 11/26/20184696
 11/27/201867163
 11/28/201842205
 11/29/201838243
 11/30/201825268
Max Date12/1/201861329

 

Appreciate your help 🙂

1 Solution

Accepted Solutions
jfkinspari
Partner - Specialist
Partner - Specialist

Within a table you can use

RangeSum(Above(Sales,0,999))

View solution in original post

2 Replies
jfkinspari
Partner - Specialist
Partner - Specialist

Within a table you can use

RangeSum(Above(Sales,0,999))

Frank_Hartmann
Master II
Master II

Or may be like this:
Rangesum(above(Sales, 0, RowNo(Total)))