topic Re: Last xx days in QlikView https://community.qlik.com/t5/QlikView/Last-xx-days/m-p/483363#M480112 <HTML><HEAD></HEAD><BODY><P>Try </P><P></P><P>=sum({&lt;Type = {Sale}, Date = {"&gt;$(=Date(Today()-30))"}&gt;}Sale.Value)</P><P></P><P>assuming Date field is showing your default date format (otherwise add appr. format code to the date function).</P></BODY></HTML> Fri, 13 Dec 2013 17:15:38 GMT swuehl 2013-12-13T17:15:38Z Last xx days https://community.qlik.com/t5/QlikView/Last-xx-days/m-p/483362#M480111 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have one easy question:-)</P><P>I have easy expression,where i need to know all sales for last xx days (today - xx days)</P><P>I tried this,but it didň´t work...thx a lot for an advice <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P></P><P>sum<SPAN style="font-size: 8pt;">({&lt;Type</SPAN><SPAN style="font-size: 8pt;">={'Sale'},</SPAN><SPAN style="color: #800000; font-size: 8pt;"><STRONG style="font-size: 14pt;">Date</STRONG></SPAN><SPAN><STRONG style="font-size: 14pt;">={'&gt;Today()-30'</STRONG>}&gt;}(Sale.Value</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P></BODY></HTML> Fri, 13 Dec 2013 17:13:07 GMT https://community.qlik.com/t5/QlikView/Last-xx-days/m-p/483362#M480111 2013-12-13T17:13:07Z Re: Last xx days https://community.qlik.com/t5/QlikView/Last-xx-days/m-p/483363#M480112 <HTML><HEAD></HEAD><BODY><P>Try </P><P></P><P>=sum({&lt;Type = {Sale}, Date = {"&gt;$(=Date(Today()-30))"}&gt;}Sale.Value)</P><P></P><P>assuming Date field is showing your default date format (otherwise add appr. format code to the date function).</P></BODY></HTML> Fri, 13 Dec 2013 17:15:38 GMT https://community.qlik.com/t5/QlikView/Last-xx-days/m-p/483363#M480112 swuehl 2013-12-13T17:15:38Z