topic Re: Count where Value in a Field not equal to in QlikView https://community.qlik.com/t5/QlikView/Count-where-Value-in-a-Field-not-equal-to/m-p/380931#M142110 <HTML><HEAD></HEAD><BODY><P>No, it doesn't. Sometimes QV shows red even though there is no error. Just try it&nbsp; out.</P></BODY></HTML> Fri, 24 Aug 2012 21:31:43 GMT bgerchikov 2012-08-24T21:31:43Z Count where Value in a Field not equal to https://community.qlik.com/t5/QlikView/Count-where-Value-in-a-Field-not-equal-to/m-p/380928#M142107 <HTML><HEAD></HEAD><BODY><P>Hi i have the following Expression:</P><P></P><P></P><P>Count({$&lt;[YearDate] = {2012}&gt;}[Location])</P><P></P><P>How can I make the same expression where the YearDate NOT equal to 2012.</P><P></P><P>I tried </P><P></P><P>Count({$&lt;[YearDate] &lt;&gt; {2012}&gt;}[Location]) but it is giving me error.</P><P></P><P>Thanks,</P></BODY></HTML> Fri, 24 Aug 2012 21:16:58 GMT https://community.qlik.com/t5/QlikView/Count-where-Value-in-a-Field-not-equal-to/m-p/380928#M142107 alec1982 2012-08-24T21:16:58Z Re: Count where Value in a Field not equal to https://community.qlik.com/t5/QlikView/Count-where-Value-in-a-Field-not-equal-to/m-p/380929#M142108 <HTML><HEAD></HEAD><BODY><P>Alec,</P><P>Try -=</P><P></P><P>Count({$&lt;[YearDate] -= {2012}&gt;}[Location])</P></BODY></HTML> Fri, 24 Aug 2012 21:20:10 GMT https://community.qlik.com/t5/QlikView/Count-where-Value-in-a-Field-not-equal-to/m-p/380929#M142108 bgerchikov 2012-08-24T21:20:10Z Re: Count where Value in a Field not equal to https://community.qlik.com/t5/QlikView/Count-where-Value-in-a-Field-not-equal-to/m-p/380930#M142109 <HTML><HEAD></HEAD><BODY><P>I am still getting a little red line under it? would that mean it is wrong?</P></BODY></HTML> Fri, 24 Aug 2012 21:27:22 GMT https://community.qlik.com/t5/QlikView/Count-where-Value-in-a-Field-not-equal-to/m-p/380930#M142109 alec1982 2012-08-24T21:27:22Z Re: Count where Value in a Field not equal to https://community.qlik.com/t5/QlikView/Count-where-Value-in-a-Field-not-equal-to/m-p/380931#M142110 <HTML><HEAD></HEAD><BODY><P>No, it doesn't. Sometimes QV shows red even though there is no error. Just try it&nbsp; out.</P></BODY></HTML> Fri, 24 Aug 2012 21:31:43 GMT https://community.qlik.com/t5/QlikView/Count-where-Value-in-a-Field-not-equal-to/m-p/380931#M142110 bgerchikov 2012-08-24T21:31:43Z