topic Condition problem in QlikView https://community.qlik.com/t5/QlikView/Condition-problem/m-p/210148#M64872 <HTML><HEAD></HEAD><BODY><P>Can't tell without knowing the format of your MonthYear field. And, the part on the right is not numeric in any case.<BR />I would do it in a different way:<BR />date &lt; makedate(year(today())-1,4)<BR />that is, date &lt; April 1, 2009, if today is year 2010.</P></BODY></HTML> Tue, 21 Sep 2010 00:53:50 GMT Anonymous 2010-09-21T00:53:50Z Condition problem https://community.qlik.com/t5/QlikView/Condition-problem/m-p/210147#M64871 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need tu build condition sth like MonthYear is lower than Apr-2010. The formula:</P><P>Num(MonthYear)&lt;num( 'Apr-' &amp; LastSalesYear)</P><P>LastSalesYear is variable.</P><P></P><BR /><BR /> <P>does not work. Can somebody help me?</P><P></P></BODY></HTML> Mon, 20 Sep 2010 23:18:53 GMT https://community.qlik.com/t5/QlikView/Condition-problem/m-p/210147#M64871 2010-09-20T23:18:53Z Condition problem https://community.qlik.com/t5/QlikView/Condition-problem/m-p/210148#M64872 <HTML><HEAD></HEAD><BODY><P>Can't tell without knowing the format of your MonthYear field. And, the part on the right is not numeric in any case.<BR />I would do it in a different way:<BR />date &lt; makedate(year(today())-1,4)<BR />that is, date &lt; April 1, 2009, if today is year 2010.</P></BODY></HTML> Tue, 21 Sep 2010 00:53:50 GMT https://community.qlik.com/t5/QlikView/Condition-problem/m-p/210148#M64872 Anonymous 2010-09-21T00:53:50Z