topic Re: Expression Help in QlikView https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793227#M1041441 <HTML><HEAD></HEAD><BODY><P>Assuming you are selecting a date/month to get last three day sales. Try expression like:</P><P>Sum({&lt;Date={"&gt;$(=Date(Max(Date)-3)) &lt;=$(=Date(Max(Date)))"}&gt;}Sales)</P></BODY></HTML> Mon, 08 Dec 2014 11:22:05 GMT tresB 2014-12-08T11:22:05Z Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793223#M1041437 <HTML><HEAD></HEAD><BODY><P>Last 3 Days sale for two year....</P><P></P><P>how can i do this?</P></BODY></HTML> Mon, 08 Dec 2014 10:26:32 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793223#M1041437 abhaysingh 2014-12-08T10:26:32Z Re: Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793224#M1041438 <HTML><HEAD></HEAD><BODY><P>Always come back(after posting) and try to see your post from others' (who know nothing about your app or requirement beyond the words you wrote) point-of-view to check if you can make out something meaningful out of that. If not, you might have to be more expressive in your question.</P></BODY></HTML> Mon, 08 Dec 2014 10:42:29 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793224#M1041438 tresB 2014-12-08T10:42:29Z Re: Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793225#M1041439 <HTML><HEAD></HEAD><BODY><P>HI TRESESCO</P><P></P><P>WHAT I WANT IS LIKE FOR YEAR 2014, </P><P>Ex in April 2014 last three days Sale april,</P><P>in may 2014 last three days sale of may and so on for rest of the month.</P><P></P><P>is it possible? if yes than what is the expression?</P></BODY></HTML> Mon, 08 Dec 2014 10:56:26 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793225#M1041439 abhaysingh 2014-12-08T10:56:26Z Re: Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793226#M1041440 <HTML><HEAD></HEAD><BODY><P>hi abhay,</P><P>use daystart() and dayend() function!</P><P></P><P>regards,</P><P>Barathiraja</P></BODY></HTML> Mon, 08 Dec 2014 11:04:42 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793226#M1041440 2014-12-08T11:04:42Z Re: Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793227#M1041441 <HTML><HEAD></HEAD><BODY><P>Assuming you are selecting a date/month to get last three day sales. Try expression like:</P><P>Sum({&lt;Date={"&gt;$(=Date(Max(Date)-3)) &lt;=$(=Date(Max(Date)))"}&gt;}Sales)</P></BODY></HTML> Mon, 08 Dec 2014 11:22:05 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793227#M1041441 tresB 2014-12-08T11:22:05Z Re: Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793228#M1041442 <HTML><HEAD></HEAD><BODY><P>sales in last 3 days of the month...</P><P>Sum({&lt;Datefield ={"&gt;=$(=date(Monthend(Datefield)-2)) &lt;=$(=date(Monthend(Datefield)))"}&gt;}Sales)</P></BODY></HTML> Mon, 08 Dec 2014 11:28:28 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793228#M1041442 PradeepReddy 2014-12-08T11:28:28Z Re: Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793229#M1041443 <HTML><HEAD></HEAD><BODY><P>Couldn't agree more</P></BODY></HTML> Mon, 08 Dec 2014 11:36:48 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/793229#M1041443 2014-12-08T11:36:48Z