This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
=RangeSum(Above(Sum(Sales), 0, RowNo()))
View solution in original post
I think you just need to remove your first total so make it
=RangeSum(Above( Sum(Sales), 0, RowNo(TOTAL)))