topic Re: InYear and &lt;Today() in QlikView https://community.qlik.com/t5/QlikView/InYear-and-lt-Today/m-p/957991#M976613 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>May be try:</P><P></P><P>=Count({&lt;[Car_Sales.Status]='Open',[Car_Sales.Anticipated Close Date] = max(year(Date)),[Car_Sales.Anticipated Close Date] = {'&lt;=$(=Date(Today()))'}&gt;()}Distinct [Sales Id])</P><P></P><P>Regards</P><P>Neetha</P></BODY></HTML> Wed, 02 Sep 2015 13:35:29 GMT Anonymous 2015-09-02T13:35:29Z InYear and <Today() https://community.qlik.com/t5/QlikView/InYear-and-lt-Today/m-p/957988#M976610 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to count the number of overdues and my expression is as follows:</P><P></P><P>=Count(Distinct If([Car_Sales.Status]='Open' AND InYear([Car_Sales.Anticipated Close Date],today(),0 AND [Car_Sales.Anticipated Close Date] &lt; Today(),[Sales Id],)))</P><P></P><P>I realize the double AND is making the error but Im unsure how to show:</P><P></P><UL><LI>Car Sales that have an 'Open' status</LI><LI>and In 2015</LI><LI>and are less than today</LI></UL><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 02 Sep 2015 13:25:47 GMT https://community.qlik.com/t5/QlikView/InYear-and-lt-Today/m-p/957988#M976610 knightwriter 2015-09-02T13:25:47Z Re: InYear and <Today() https://community.qlik.com/t5/QlikView/InYear-and-lt-Today/m-p/957989#M976611 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please try this: </P><TABLE><TBODY><TR><TD>Count(Distinct</TD><TD><P>If([Car_Sales.Status]='Open' AND InYear([Car_Sales.Anticipated Close Date],today(),0) AND [Car_Sales.Anticipated Close Date] &lt; Today(),[Sales Id]))</P></TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks,</P><P>Juan</P></BODY></HTML> Wed, 02 Sep 2015 13:29:41 GMT https://community.qlik.com/t5/QlikView/InYear-and-lt-Today/m-p/957989#M976611 jvitantonio 2015-09-02T13:29:41Z Re: InYear and <Today() https://community.qlik.com/t5/QlikView/InYear-and-lt-Today/m-p/957990#M976612 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Count(DISTINCT {&lt;Year = {"$(=Year(Today()))"}, [Car_Sales.Status] = {'Open'}, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[Car_Sales.Anticipated Close Date] = {"$(='&lt;=' &amp; Date(Today(), 'YourDateFormat'))"}</SPAN>&gt;} [Sales Id])</STRONG></P></BODY></HTML> Wed, 02 Sep 2015 13:32:05 GMT https://community.qlik.com/t5/QlikView/InYear-and-lt-Today/m-p/957990#M976612 sunny_talwar 2015-09-02T13:32:05Z Re: InYear and <Today() https://community.qlik.com/t5/QlikView/InYear-and-lt-Today/m-p/957991#M976613 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>May be try:</P><P></P><P>=Count({&lt;[Car_Sales.Status]='Open',[Car_Sales.Anticipated Close Date] = max(year(Date)),[Car_Sales.Anticipated Close Date] = {'&lt;=$(=Date(Today()))'}&gt;()}Distinct [Sales Id])</P><P></P><P>Regards</P><P>Neetha</P></BODY></HTML> Wed, 02 Sep 2015 13:35:29 GMT https://community.qlik.com/t5/QlikView/InYear-and-lt-Today/m-p/957991#M976613 Anonymous 2015-09-02T13:35:29Z