topic Rollback 28 days expression in QlikView https://community.qlik.com/t5/QlikView/Rollback-28-days-expression/m-p/1081718#M933373 <HTML><HEAD></HEAD><BODY><P>I use the following expression to calculate an average rolling back 28 days </P><P></P><P>((Sum({&lt;Promo ={0},DateTest={"&gt;=$(=Date(Today() - 30)) &lt;$(=Date(Today()-2))"}&gt;} [Prix de vente TTC]))/28 )</P><P>how to make a rollback in case <SPAN style="font-size: 13.3333px;">Promo ={0} for 28 days ? How to make a rolback for the 28 fisrt days back where <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Promo ={0} ?</SPAN></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Rollback 28 days expression https://community.qlik.com/t5/QlikView/Rollback-28-days-expression/m-p/1081718#M933373 <HTML><HEAD></HEAD><BODY><P>I use the following expression to calculate an average rolling back 28 days </P><P></P><P>((Sum({&lt;Promo ={0},DateTest={"&gt;=$(=Date(Today() - 30)) &lt;$(=Date(Today()-2))"}&gt;} [Prix de vente TTC]))/28 )</P><P>how to make a rollback in case <SPAN style="font-size: 13.3333px;">Promo ={0} for 28 days ? How to make a rolback for the 28 fisrt days back where <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Promo ={0} ?</SPAN></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Rollback-28-days-expression/m-p/1081718#M933373 Anonymous 2020-11-25T16:16:04Z Re: Rollback 28 days expression https://community.qlik.com/t5/QlikView/Rollback-28-days-expression/m-p/1081719#M933374 <HTML><HEAD></HEAD><BODY><P>=if(agg<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">(Sum({&lt;Promo ={0},DateTest={"&gt;=$(=Date(Today() - 30)) &lt;$(=Date(Today()-2))"}&gt;} [Prix de vente TTC]))/28 ))</SPAN></P></BODY></HTML> Thu, 03 Mar 2016 11:07:25 GMT https://community.qlik.com/t5/QlikView/Rollback-28-days-expression/m-p/1081719#M933374 Chanty4u 2016-03-03T11:07:25Z