topic Week wise Cumulative Sum reset to zero on month start in QlikView https://community.qlik.com/t5/QlikView/Week-wise-Cumulative-Sum-reset-to-zero-on-month-start/m-p/1160374#M378326 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a set of data as attached.</P><P>I need cumulative sum at plant level and week level but not at month or year level.</P><P></P><P>At the start of every new month, the cumulative sum should start from 0.</P><P></P><P>I tried rangesum &amp; above but could not achieve the desired result.</P><P>Please refer the input &amp; output tab in the attached excel.</P><P></P><P>Request all to help me.</P><P></P><P>Thanks in advance.</P><P>Sarang M. Mehta</P></BODY></HTML> Thu, 09 Jun 2016 11:05:18 GMT sarangmmehta 2016-06-09T11:05:18Z Week wise Cumulative Sum reset to zero on month start https://community.qlik.com/t5/QlikView/Week-wise-Cumulative-Sum-reset-to-zero-on-month-start/m-p/1160374#M378326 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a set of data as attached.</P><P>I need cumulative sum at plant level and week level but not at month or year level.</P><P></P><P>At the start of every new month, the cumulative sum should start from 0.</P><P></P><P>I tried rangesum &amp; above but could not achieve the desired result.</P><P>Please refer the input &amp; output tab in the attached excel.</P><P></P><P>Request all to help me.</P><P></P><P>Thanks in advance.</P><P>Sarang M. Mehta</P></BODY></HTML> Thu, 09 Jun 2016 11:05:18 GMT https://community.qlik.com/t5/QlikView/Week-wise-Cumulative-Sum-reset-to-zero-on-month-start/m-p/1160374#M378326 sarangmmehta 2016-06-09T11:05:18Z