topic Set analysis based on date stopped working, why? in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-based-on-date-stopped-working-why/m-p/379994#M141756 <HTML><HEAD></HEAD><BODY><P>I am using the following Expression (built using <A _jive_internal="true" href="https://community.qlik.com/thread/34976">this </A>as a working example originally) to count all Enquiries that have an Opened Date in the last calendar month...</P><P></P><TABLE><TBODY><TR><TD>=COUNT({&lt;OPENEDDATE = {"&gt;=$(=monthstart(addmonths(today(),-1)))&lt;$(=monthstart(today()))"}&gt;} ENQUIRY)</TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P></P><P>This was working perfectly up until recently when I returned to work on the chart and develop it further, but is now not working at all. </P><P></P><P>Any Ideas as to why this has suddenly refused to work? There is a lot of recent data in there that is within the two date ranges.</P></BODY></HTML> Wed, 22 Aug 2012 15:33:31 GMT 2012-08-22T15:33:31Z Set analysis based on date stopped working, why? https://community.qlik.com/t5/QlikView/Set-analysis-based-on-date-stopped-working-why/m-p/379994#M141756 <HTML><HEAD></HEAD><BODY><P>I am using the following Expression (built using <A _jive_internal="true" href="https://community.qlik.com/thread/34976">this </A>as a working example originally) to count all Enquiries that have an Opened Date in the last calendar month...</P><P></P><TABLE><TBODY><TR><TD>=COUNT({&lt;OPENEDDATE = {"&gt;=$(=monthstart(addmonths(today(),-1)))&lt;$(=monthstart(today()))"}&gt;} ENQUIRY)</TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P></P><P>This was working perfectly up until recently when I returned to work on the chart and develop it further, but is now not working at all. </P><P></P><P>Any Ideas as to why this has suddenly refused to work? There is a lot of recent data in there that is within the two date ranges.</P></BODY></HTML> Wed, 22 Aug 2012 15:33:31 GMT https://community.qlik.com/t5/QlikView/Set-analysis-based-on-date-stopped-working-why/m-p/379994#M141756 2012-08-22T15:33:31Z Re: Set analysis based on date stopped working, why? https://community.qlik.com/t5/QlikView/Set-analysis-based-on-date-stopped-working-why/m-p/379995#M141757 <HTML><HEAD></HEAD><BODY><P>During this period did any changes were made to the QVW or an upgrade happened? Also check the format of OPENEDDATE and return on set expressions.</P><P></P><P>Kiran.</P></BODY></HTML> Wed, 22 Aug 2012 16:36:44 GMT https://community.qlik.com/t5/QlikView/Set-analysis-based-on-date-stopped-working-why/m-p/379995#M141757 2012-08-22T16:36:44Z