Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
freceena
Contributor II
Contributor II

Cumulative sum of a column based on another columns in expression editor

I have to get cumsales field by the summation of sales for months and cum_category_count should be the cumulative count of category with respect to category and month. Could anyone please suggest a solution for this?

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

you need an expression something like this

=Aggr(RangeSum(Above(Sum(sales), 0, RowNo())), category, (date, (NUMERIC))).

attached output from my  sample dataCapture.PNG