topic Re: Week sum - previous week in App Development https://community.qlik.com/t5/App-Development/Week-sum-previous-week/m-p/103935#M7044 <HTML><HEAD></HEAD><BODY><P>Can you share sample data?</P></BODY></HTML> Mon, 24 Sep 2018 20:01:20 GMT poluvidyasagar 2018-09-24T20:01:20Z Week sum - previous week https://community.qlik.com/t5/App-Development/Week-sum-previous-week/m-p/103934#M7043 <HTML><HEAD></HEAD><BODY><P>Trying to use RangeSum function to sum sales values based on the weeknum function.&nbsp; Basically, when I use this function, I would like the results to show value for last total week when used in table.</P><P></P><P>Example:</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp; Weeknum&nbsp;&nbsp;&nbsp;&nbsp; New Measure</P><P>9/10:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total from Week Four</P><P>9/11:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Total from Week Four</SPAN></P><P>9/12:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Total from Week Five</SPAN></P><P>9/13:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Total from Week Five...&nbsp; etc</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Is there any way to achieve something similar to this, maybe using different functions?&nbsp; The expression I made did not produce proper values.&nbsp; Any help is appreciated.<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P></BODY></HTML> Mon, 24 Sep 2018 19:17:47 GMT https://community.qlik.com/t5/App-Development/Week-sum-previous-week/m-p/103934#M7043 Anonymous 2018-09-24T19:17:47Z Re: Week sum - previous week https://community.qlik.com/t5/App-Development/Week-sum-previous-week/m-p/103935#M7044 <HTML><HEAD></HEAD><BODY><P>Can you share sample data?</P></BODY></HTML> Mon, 24 Sep 2018 20:01:20 GMT https://community.qlik.com/t5/App-Development/Week-sum-previous-week/m-p/103935#M7044 poluvidyasagar 2018-09-24T20:01:20Z