topic Re: Calculating Overdue... in QlikView https://community.qlik.com/t5/QlikView/Calculating-Overdue/m-p/655661#M239418 <HTML><HEAD></HEAD><BODY><P>LOAD DateToCompare,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(DateToCompare &lt;= Date+30, 'On Time', 'Overdue') as [On Time]</P><P>FROM yoursource;</P></BODY></HTML> Sat, 18 Oct 2014 08:05:35 GMT MarcoWedel 2014-10-18T08:05:35Z Calculating Overdue... https://community.qlik.com/t5/QlikView/Calculating-Overdue/m-p/655660#M239417 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>this is really stumping me.</P><P></P><P>I want to show based on a calculation of On Time &lt;= &lt;Date&gt; + 30, and Overdue &gt; &lt;Date&gt; + 30</P><P></P><P>Can I get a bit of direction here please <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>thanks,</P><P>-L</P></BODY></HTML> Fri, 17 Oct 2014 20:55:44 GMT https://community.qlik.com/t5/QlikView/Calculating-Overdue/m-p/655660#M239417 leocattqv 2014-10-17T20:55:44Z Re: Calculating Overdue... https://community.qlik.com/t5/QlikView/Calculating-Overdue/m-p/655661#M239418 <HTML><HEAD></HEAD><BODY><P>LOAD DateToCompare,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(DateToCompare &lt;= Date+30, 'On Time', 'Overdue') as [On Time]</P><P>FROM yoursource;</P></BODY></HTML> Sat, 18 Oct 2014 08:05:35 GMT https://community.qlik.com/t5/QlikView/Calculating-Overdue/m-p/655661#M239418 MarcoWedel 2014-10-18T08:05:35Z