Cummulative sales from Month Start to selected date?

[dmohanty]

Hi All,

We have to make any selections on a particular date. Now the chart should show the cummulative sales from the Month Start till the selected date.

How to achieve this?

Regards!!

[#2]

For cumulative sum use:

RangeSum(Above(total sum(Sales),0,RowNo()))

Replace "Sales" with your column name

Hope this helps!

Edit: Also, you can refer to this:

http://community.qlik.com/message/432822

[whiteline]

Hi.

The easiest way is to use Accumulation option (Chart Properties, Expressions tab) for the sales expression.