topic Re: Set analysis syntax in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/530754#M198408 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the Date Format of Due_Date Field and the date comming from today() functions. Both should be same.</P><P></P><P>-Nilesh</P></BODY></HTML> Thu, 05 Dec 2013 05:11:03 GMT nilesh_gangurde 2013-12-05T05:11:03Z Set analysis syntax https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/530753#M198407 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi,</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Is this correct? I only want to sum the counter where the due date is within the last 30 days ? It does not seem to be working correctly. </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Sum({&lt;<SPAN style="color: #800000;">Due_Date</SPAN>={<SPAN style="color: #800000;">"&gt;=$(=Today()-30)&lt;=$(=Today())"</SPAN>}&gt;}<SPAN style="color: #800000;">Late_Counter</SPAN>) </SPAN></P><P></P><P><SPAN><SPAN style="font-size: 10pt;">Thanks!</SPAN></SPAN></P><P></P></BODY></HTML> Thu, 05 Dec 2013 05:06:30 GMT https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/530753#M198407 regowins 2013-12-05T05:06:30Z Re: Set analysis syntax https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/530754#M198408 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the Date Format of Due_Date Field and the date comming from today() functions. Both should be same.</P><P></P><P>-Nilesh</P></BODY></HTML> Thu, 05 Dec 2013 05:11:03 GMT https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/530754#M198408 nilesh_gangurde 2013-12-05T05:11:03Z Re: Set analysis syntax https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/530755#M198409 <HTML><HEAD></HEAD><BODY><P>Thanks I will check.</P></BODY></HTML> Fri, 06 Dec 2013 01:50:00 GMT https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/530755#M198409 regowins 2013-12-06T01:50:00Z