topic Issue with comparative expressions... in QlikView https://community.qlik.com/t5/QlikView/Issue-with-comparative-expressions/m-p/276816#M1205215 <HTML><HEAD></HEAD><BODY><P>Can you post your qvw here? May be with reduced data.</P></BODY></HTML> Thu, 16 Sep 2010 02:33:57 GMT disqr_rm 2010-09-16T02:33:57Z Issue with comparative expressions... https://community.qlik.com/t5/QlikView/Issue-with-comparative-expressions/m-p/276815#M1205214 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>If I use this expression: <STRONG>Sum (if (InYear ([DATE], Today(), 0), [SALES]))</STRONG></P><P>against: <STRONG>Sum (if (InYear ([DATE], Today(), -1), [SALES]))</STRONG></P><P>returns the comparison in a bar chart of the selected month in the current year against the same month last year...the issue arises when the month in the last year has no record of data. Then, the program assigns the same value for both months although, last year's value should appear as zero.</P><P>Does anyone know a way to overcome this?</P><P>Thanks in advance</P></BODY></HTML> Wed, 15 Sep 2010 22:11:30 GMT https://community.qlik.com/t5/QlikView/Issue-with-comparative-expressions/m-p/276815#M1205214 2010-09-15T22:11:30Z Issue with comparative expressions... https://community.qlik.com/t5/QlikView/Issue-with-comparative-expressions/m-p/276816#M1205215 <HTML><HEAD></HEAD><BODY><P>Can you post your qvw here? May be with reduced data.</P></BODY></HTML> Thu, 16 Sep 2010 02:33:57 GMT https://community.qlik.com/t5/QlikView/Issue-with-comparative-expressions/m-p/276816#M1205215 disqr_rm 2010-09-16T02:33:57Z