topic Re: Today() and the load in QlikView https://community.qlik.com/t5/QlikView/Today-and-the-load/m-p/788256#M1041014 <HTML><HEAD></HEAD><BODY><P>You cannot use set analysis in the script. So <SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">[AUDIT_DUE]</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> = {</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">"&lt;=$(=Date(Today(),'MM/DD/YYYY'))"</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">}&gt;}</SPAN> is meaningless in the script. It's also not correct when used in an aggregation function in a chart expression.</P><P>Try instead: if([AUDIT_DUE] &lt;= today(), 'On Time', 'Overdue') as [On Time]</P></BODY></HTML> Wed, 24 Dec 2014 19:01:10 GMT Gysbert_Wassenaar 2014-12-24T19:01:10Z Today() and the load https://community.qlik.com/t5/QlikView/Today-and-the-load/m-p/788255#M1041013 <HTML><HEAD></HEAD><BODY><P>Merry Christmas everyone,</P><P></P><P>I am needing to create a calculated field that will give me late and ontime.&nbsp; this is what I have but I am getting syntax errors.</P><P></P><P>Any suggestions?</P><P></P><P></P><P>IF</P><P></P><P>(<SPAN style="color: #800000;">[AUDIT_DUE]</SPAN> = {<SPAN style="color: #800000;">"&lt;=$(=Date(Today(),'MM/DD/YYYY'))"</SPAN>}&gt;}'On Time', 'Overdue') as <SPAN style="color: #800000;">[On Time]</SPAN>,</P></BODY></HTML> Wed, 24 Dec 2014 18:51:08 GMT https://community.qlik.com/t5/QlikView/Today-and-the-load/m-p/788255#M1041013 leocattqv 2014-12-24T18:51:08Z Re: Today() and the load https://community.qlik.com/t5/QlikView/Today-and-the-load/m-p/788256#M1041014 <HTML><HEAD></HEAD><BODY><P>You cannot use set analysis in the script. So <SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">[AUDIT_DUE]</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> = {</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">"&lt;=$(=Date(Today(),'MM/DD/YYYY'))"</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">}&gt;}</SPAN> is meaningless in the script. It's also not correct when used in an aggregation function in a chart expression.</P><P>Try instead: if([AUDIT_DUE] &lt;= today(), 'On Time', 'Overdue') as [On Time]</P></BODY></HTML> Wed, 24 Dec 2014 19:01:10 GMT https://community.qlik.com/t5/QlikView/Today-and-the-load/m-p/788256#M1041014 Gysbert_Wassenaar 2014-12-24T19:01:10Z Re: Today() and the load https://community.qlik.com/t5/QlikView/Today-and-the-load/m-p/788257#M1041015 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.63636302948px;">Hello Leo,</P><P style="font-size: 13.63636302948px;"></P><P style="font-size: 13.63636302948px;">Don't forget to mark answers as helpful or correct.</P><P style="font-size: 13.63636302948px;"><SPAN style="font-size: 10pt;">Thanks for sharing the solution you found and closing the discussion.</SPAN></P><P style="font-size: 13.63636302948px;"></P><P style="font-size: 13.63636302948px;">,KR Koen</P></BODY></HTML> Wed, 24 Dec 2014 23:25:58 GMT https://community.qlik.com/t5/QlikView/Today-and-the-load/m-p/788257#M1041015 cheburashka 2014-12-24T23:25:58Z Re: Today() and the load https://community.qlik.com/t5/QlikView/Today-and-the-load/m-p/788258#M1041016 <HTML><HEAD></HEAD><BODY><P>That did it.</P><P></P><P>thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 29 Dec 2014 16:20:59 GMT https://community.qlik.com/t5/QlikView/Today-and-the-load/m-p/788258#M1041016 leocattqv 2014-12-29T16:20:59Z