topic cumulative sales.. in QlikView https://community.qlik.com/t5/QlikView/cumulative-sales/m-p/862468#M1014116 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If you make selection on any date , it should show cumulative sales from month start till the selected</P><P>date.How will you do it?</P></BODY></HTML> Sun, 19 Apr 2015 07:28:19 GMT prabhas277 2015-04-19T07:28:19Z cumulative sales.. https://community.qlik.com/t5/QlikView/cumulative-sales/m-p/862468#M1014116 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If you make selection on any date , it should show cumulative sales from month start till the selected</P><P>date.How will you do it?</P></BODY></HTML> Sun, 19 Apr 2015 07:28:19 GMT https://community.qlik.com/t5/QlikView/cumulative-sales/m-p/862468#M1014116 prabhas277 2015-04-19T07:28:19Z Re: cumulative sales.. https://community.qlik.com/t5/QlikView/cumulative-sales/m-p/862469#M1014117 <HTML><HEAD></HEAD><BODY><P>You can do it by Set Analysis...</P><P>Considering that the date field name is InvoiceDate and you also have InvoiceYear, InvoiceQuarter, InvoiceMonth, InvoiceWeek....</P><P></P><P></P><P>=SUM({&lt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InvoiceYear=, InvoiceMonth=, InvoiceQuarter=, InvoiceWee=,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InvoiceDate = {"&gt;=$(=Date(MonthStart(Max(InvoiceDate))))&lt;=$(=Date(Max(InvoiceDate)))"}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;}Sales)</P></BODY></HTML> Sun, 19 Apr 2015 07:43:44 GMT https://community.qlik.com/t5/QlikView/cumulative-sales/m-p/862469#M1014117 MK_QSL 2015-04-19T07:43:44Z