topic Re: Does not = in QlikView https://community.qlik.com/t5/QlikView/Does-not/m-p/607037#M1118182 <HTML><HEAD></HEAD><BODY><P>no that didnt work either, kind of worked for 1 or 2 lines but not all of them??</P></BODY></HTML> Tue, 04 Feb 2014 16:40:27 GMT Anonymous 2014-02-04T16:40:27Z Does not = https://community.qlik.com/t5/QlikView/Does-not/m-p/607035#M1118180 <HTML><HEAD></HEAD><BODY><P>hi, sorry if this is a very simplistic question but i've wasted all afternoon trying to figure it out.,..</P><P>i have a table in which i have the following expression:</P><P>IF (DocumentType = 'C', NetSalesValue)&nbsp; </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">...this seems to work ok, but i also want an expression that shows everything but 'C'... </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">i presumed something like:</SPAN></P><P>IF (DocumentType &lt;&gt; 'C', NetSalesValue)</P><P>...&nbsp; would work but it doesnt??&nbsp; what am i doing wrong?&nbsp; </P></BODY></HTML> Tue, 04 Feb 2014 16:30:12 GMT https://community.qlik.com/t5/QlikView/Does-not/m-p/607035#M1118180 Anonymous 2014-02-04T16:30:12Z Re: Does not = https://community.qlik.com/t5/QlikView/Does-not/m-p/607036#M1118181 <HTML><HEAD></HEAD><BODY><P>it should work...</P><P>try <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">IF (not DocumentType = 'C', NetSalesValue) </SPAN></P></BODY></HTML> Tue, 04 Feb 2014 16:33:07 GMT https://community.qlik.com/t5/QlikView/Does-not/m-p/607036#M1118181 Clever_Anjos 2014-02-04T16:33:07Z Re: Does not = https://community.qlik.com/t5/QlikView/Does-not/m-p/607037#M1118182 <HTML><HEAD></HEAD><BODY><P>no that didnt work either, kind of worked for 1 or 2 lines but not all of them??</P></BODY></HTML> Tue, 04 Feb 2014 16:40:27 GMT https://community.qlik.com/t5/QlikView/Does-not/m-p/607037#M1118182 Anonymous 2014-02-04T16:40:27Z Re: Does not = https://community.qlik.com/t5/QlikView/Does-not/m-p/607038#M1118183 <HTML><HEAD></HEAD><BODY><P>Hi James</P><P></P><P>you can use set analysis</P><P></P><P>sum({&lt;DocumentType =-{'C'}&gt;} NetSalesValue)&nbsp;&nbsp; gives everything but C</P><P>or</P><P>sum({&lt;DocumentType =E{'C'}&gt;} NetSalesValue)&nbsp;&nbsp; excludes C</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Tue, 04 Feb 2014 16:45:36 GMT https://community.qlik.com/t5/QlikView/Does-not/m-p/607038#M1118183 2014-02-04T16:45:36Z Re: Does not = https://community.qlik.com/t5/QlikView/Does-not/m-p/607039#M1118184 <HTML><HEAD></HEAD><BODY><P>It should work. Can you post the offending document that demonstrates the problem?</P></BODY></HTML> Tue, 04 Feb 2014 16:45:42 GMT https://community.qlik.com/t5/QlikView/Does-not/m-p/607039#M1118184 Gysbert_Wassenaar 2014-02-04T16:45:42Z Re: Does not = https://community.qlik.com/t5/QlikView/Does-not/m-p/607040#M1118185 <HTML><HEAD></HEAD><BODY><P>Yep, bang on - thanks</P></BODY></HTML> Tue, 04 Feb 2014 16:54:03 GMT https://community.qlik.com/t5/QlikView/Does-not/m-p/607040#M1118185 Anonymous 2014-02-04T16:54:03Z