topic Re: Can you make the set analysis work in QlikView https://community.qlik.com/t5/QlikView/Can-you-make-the-set-analysis-work/m-p/1009298#M342592 <HTML><HEAD></HEAD><BODY><P>Appropriate expression is:</P><P>sum({&lt;WorkDay ={"=date#(only({1}WorkDay),'M/D/YYYY')&gt;=$(#=date(vDay-7)) and date#(only({1}WorkDay),'M/D/YYYY') &lt;=$(#=vDay)"}&gt;} Sales)</P></BODY></HTML> Mon, 30 Nov 2015 16:08:42 GMT 2015-11-30T16:08:42Z Can you make the set analysis work https://community.qlik.com/t5/QlikView/Can-you-make-the-set-analysis-work/m-p/1009295#M342589 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>Can any expert make this set analysis working. I want show 7 days by any given date?</P><P></P><P>Thank you very much in advance!</P></BODY></HTML> Mon, 30 Nov 2015 15:53:25 GMT https://community.qlik.com/t5/QlikView/Can-you-make-the-set-analysis-work/m-p/1009295#M342589 2015-11-30T15:53:25Z Re: Can you make the set analysis work https://community.qlik.com/t5/QlikView/Can-you-make-the-set-analysis-work/m-p/1009296#M342590 <HTML><HEAD></HEAD><BODY><P>Seems to be a date issue. Check the attached one which seems to work now</P></BODY></HTML> Mon, 30 Nov 2015 16:05:09 GMT https://community.qlik.com/t5/QlikView/Can-you-make-the-set-analysis-work/m-p/1009296#M342590 sunny_talwar 2015-11-30T16:05:09Z Re: Can you make the set analysis work https://community.qlik.com/t5/QlikView/Can-you-make-the-set-analysis-work/m-p/1009297#M342591 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>Thank you very much. You are the best!</P><P></P><P>Very much Appreciate.</P></BODY></HTML> Mon, 30 Nov 2015 16:08:16 GMT https://community.qlik.com/t5/QlikView/Can-you-make-the-set-analysis-work/m-p/1009297#M342591 2015-11-30T16:08:16Z Re: Can you make the set analysis work https://community.qlik.com/t5/QlikView/Can-you-make-the-set-analysis-work/m-p/1009298#M342592 <HTML><HEAD></HEAD><BODY><P>Appropriate expression is:</P><P>sum({&lt;WorkDay ={"=date#(only({1}WorkDay),'M/D/YYYY')&gt;=$(#=date(vDay-7)) and date#(only({1}WorkDay),'M/D/YYYY') &lt;=$(#=vDay)"}&gt;} Sales)</P></BODY></HTML> Mon, 30 Nov 2015 16:08:42 GMT https://community.qlik.com/t5/QlikView/Can-you-make-the-set-analysis-work/m-p/1009298#M342592 2015-11-30T16:08:42Z