topic Week Measure in App Development https://community.qlik.com/t5/App-Development/Week-Measure/m-p/135048#M9484 <HTML><HEAD></HEAD><BODY><P>Trying to create a measure that will, based on whatever date, retrieve the prior weeks total.&nbsp; Basically table should look like following:</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp; Week&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>9/15&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Week 0 Total</P><P>9/16&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Week 0 Total</P><P>9/17&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Week 1 Total</P><P>9/18&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Week 1 Total... so on...</P><P></P><P>I am aware that week numbers are incorrect, just trying to provide an example of what I am trying to create.&nbsp; I have an expression, but it does not correctly display data, rather weeks are rolling.</P><P></P><P>Any help is appreciated, thanks in advance for any help.</P></BODY></HTML> Mon, 17 Sep 2018 20:10:32 GMT Anonymous 2018-09-17T20:10:32Z Week Measure https://community.qlik.com/t5/App-Development/Week-Measure/m-p/135048#M9484 <HTML><HEAD></HEAD><BODY><P>Trying to create a measure that will, based on whatever date, retrieve the prior weeks total.&nbsp; Basically table should look like following:</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp; Week&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>9/15&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Week 0 Total</P><P>9/16&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Week 0 Total</P><P>9/17&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Week 1 Total</P><P>9/18&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Week 1 Total... so on...</P><P></P><P>I am aware that week numbers are incorrect, just trying to provide an example of what I am trying to create.&nbsp; I have an expression, but it does not correctly display data, rather weeks are rolling.</P><P></P><P>Any help is appreciated, thanks in advance for any help.</P></BODY></HTML> Mon, 17 Sep 2018 20:10:32 GMT https://community.qlik.com/t5/App-Development/Week-Measure/m-p/135048#M9484 Anonymous 2018-09-17T20:10:32Z