topic Re: expression? in QlikView https://community.qlik.com/t5/QlikView/expression/m-p/96737#M15528 <HTML><HEAD></HEAD><BODY><P>thanks for posting its working</P></BODY></HTML> Fri, 03 Aug 2018 07:46:39 GMT Anonymous 2018-08-03T07:46:39Z expression? https://community.qlik.com/t5/QlikView/expression/m-p/96734#M15525 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i am facing an issue with task</P><P>i have three field like if select any date it show previous week total sales. like i select 9/8/2018 it will show 1/8/2018 To 7/8/2018 total sales </P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>1/8/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>2/8/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></P><P>3/8/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></P><P><SPAN style="font-size: 13.3333px;">4/8/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">5/8/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">6/8/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN>&nbsp; </SPAN></P><P><SPAN style="font-size: 13.3333px;">7/8/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">8/8/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">9/8/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">10/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">11/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">11/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">12/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">13/8/2017&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">&nbsp; </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">14/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">15/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">16/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">17/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">18/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">19/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">20</SPAN><SPAN style="font-size: 13.3333px;">/8/2017&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px;">Toys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Thu, 02 Aug 2018 07:50:21 GMT https://community.qlik.com/t5/QlikView/expression/m-p/96734#M15525 Anonymous 2018-08-02T07:50:21Z Re: expression? https://community.qlik.com/t5/QlikView/expression/m-p/96735#M15526 <HTML><HEAD></HEAD><BODY><P>What's the expression you used? And what is your requirement?</P></BODY></HTML> Thu, 02 Aug 2018 14:58:46 GMT https://community.qlik.com/t5/QlikView/expression/m-p/96735#M15526 BalaBhaskar_Qlik 2018-08-02T14:58:46Z Re: expression? https://community.qlik.com/t5/QlikView/expression/m-p/96736#M15527 <HTML><HEAD></HEAD><BODY><P>Hi, it works with :</P><P></P><P>=sum({&lt;Date={"&gt;=$(=WeekStart(Date,-1))&nbsp; &lt;=$(=WeekEnd(Date,-1))"}&gt;} Sales)</P><P></P><P><IMG alt="P8.jpg" class="jive-image image-1" height="263" src="https://community.qlik.com/legacyfs/online/209732_P8.jpg" style="height: 262.5px; width: 525px;" width="525" /></P></BODY></HTML> Thu, 02 Aug 2018 15:17:13 GMT https://community.qlik.com/t5/QlikView/expression/m-p/96736#M15527 sergio0592 2018-08-02T15:17:13Z Re: expression? https://community.qlik.com/t5/QlikView/expression/m-p/96737#M15528 <HTML><HEAD></HEAD><BODY><P>thanks for posting its working</P></BODY></HTML> Fri, 03 Aug 2018 07:46:39 GMT https://community.qlik.com/t5/QlikView/expression/m-p/96737#M15528 Anonymous 2018-08-03T07:46:39Z