topic Re: Set analysis problem in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/819781#M289014 <HTML><HEAD></HEAD><BODY><P>it will work by using this...</P><P>vEndDate =today()</P><P>vStartDate =firstworkdate(vEndDate,2)</P><P>=Sum({&lt;SalesDate={'&gt;=$(=vStartDate)&lt;=$(=vEndDate)'}&gt;}Sales)</P></BODY></HTML> Tue, 17 Feb 2015 13:17:29 GMT Anonymous 2015-02-17T13:17:29Z Set analysis problem https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/819780#M289013 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #141823; font-family: Helvetica, Arial, 'lucida grande', tahoma, verdana, arial, sans-serif; font-size: 14px;">can anybody correct this one??</SPAN></P><P><SPAN style="color: #141823; font-family: Helvetica, Arial, 'lucida grande', tahoma, verdana, arial, sans-serif; font-size: 14px;">basically this expression shows all calls for previous day on that date, if Monday comes the expression should show on Friday data,can anybody help me out??</SPAN></P><P><SPAN style="color: #141823; font-family: Helvetica, Arial, 'lucida grande', tahoma, verdana, arial, sans-serif; font-size: 14px;">Only({1&lt;row_date={'$(=Date(Today()-1))'</SPAN></P><P><SPAN style="color: #141823; font-family: Helvetica, Arial, 'lucida grande', tahoma, verdana, arial, sans-serif; font-size: 14px;">}, if(WeekDay='Mon',date(max(row_date-3)&gt;}agentacdcalls))</SPAN></P></BODY></HTML> Tue, 17 Feb 2015 09:59:01 GMT https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/819780#M289013 Anonymous 2015-02-17T09:59:01Z Re: Set analysis problem https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/819781#M289014 <HTML><HEAD></HEAD><BODY><P>it will work by using this...</P><P>vEndDate =today()</P><P>vStartDate =firstworkdate(vEndDate,2)</P><P>=Sum({&lt;SalesDate={'&gt;=$(=vStartDate)&lt;=$(=vEndDate)'}&gt;}Sales)</P></BODY></HTML> Tue, 17 Feb 2015 13:17:29 GMT https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/819781#M289014 Anonymous 2015-02-17T13:17:29Z