Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
tuxo9999
Contributor II
Contributor II

Acumulative Sales

Hello,

I would like to make an expression than accumalates sales per month.

i have data from 2015 to ytd so i would like on the new year to start accumlating from 0

i mean imagine that on December 2015 i have 3000 sales, and on January 16 54 sales.

the data on jan 16 should be 54.

i have seen this formula, however it sums all the data and it doesn´t take into account the year.

=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))

How to Calculate the Cumulative Month sales

thank you

1 Solution

Accepted Solutions
sunny_talwar

or this

=RangeSum(Above(Sum(Sales), 0, RowNo()))

View solution in original post

2 Replies
adamdavi3s
Master
Master

I think you just need to remove your first total so make it

=RangeSum(Above( Sum(Sales), 0, RowNo(TOTAL)))

sunny_talwar

or this

=RangeSum(Above(Sum(Sales), 0, RowNo()))

View solution in original post