topic different sign not work in QlikView https://community.qlik.com/t5/QlikView/different-sign-not-work/m-p/376285#M140263 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I want to use</SPAN> <SPAN class="hps">different sign</SPAN> <SPAN class="hps">to exclude values</SPAN> <SPAN class="hps">​​and</SPAN> <SPAN class="hps">not working.</SPAN><BR /><BR /><SPAN class="hps">for example</SPAN><SPAN>:</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Id_Division &lt;&gt; 02, nombredivision) AS ndivision </SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN class="hps">but it</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">assimilating</SPAN></P><P></P><P><SPAN class="hps">help please</SPAN></P><P></P><P>thank </P></BODY></HTML> Wed, 08 Aug 2012 15:28:45 GMT 2012-08-08T15:28:45Z different sign not work https://community.qlik.com/t5/QlikView/different-sign-not-work/m-p/376285#M140263 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I want to use</SPAN> <SPAN class="hps">different sign</SPAN> <SPAN class="hps">to exclude values</SPAN> <SPAN class="hps">​​and</SPAN> <SPAN class="hps">not working.</SPAN><BR /><BR /><SPAN class="hps">for example</SPAN><SPAN>:</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Id_Division &lt;&gt; 02, nombredivision) AS ndivision </SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN class="hps">but it</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">assimilating</SPAN></P><P></P><P><SPAN class="hps">help please</SPAN></P><P></P><P>thank </P></BODY></HTML> Wed, 08 Aug 2012 15:28:45 GMT https://community.qlik.com/t5/QlikView/different-sign-not-work/m-p/376285#M140263 2012-08-08T15:28:45Z Re: different sign not work https://community.qlik.com/t5/QlikView/different-sign-not-work/m-p/376286#M140264 <HTML><HEAD></HEAD><BODY><P>Did u try it on Front -End??</P><P>If it works then try in script...</P></BODY></HTML> Thu, 09 Aug 2012 06:59:57 GMT https://community.qlik.com/t5/QlikView/different-sign-not-work/m-p/376286#M140264 rajni_batra 2012-08-09T06:59:57Z Re: different sign not work https://community.qlik.com/t5/QlikView/different-sign-not-work/m-p/376287#M140265 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try <SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(NOT MATCH(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Id_Division,02), nombredivision) AS ndivision </SPAN></P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Thu, 09 Aug 2012 07:12:16 GMT https://community.qlik.com/t5/QlikView/different-sign-not-work/m-p/376287#M140265 Sokkorn 2012-08-09T07:12:16Z Re: different sign not work https://community.qlik.com/t5/QlikView/different-sign-not-work/m-p/376288#M140266 <HTML><HEAD></HEAD><BODY><P>you have to be carefull with leading zeros</P></BODY></HTML> Thu, 09 Aug 2012 09:00:47 GMT https://community.qlik.com/t5/QlikView/different-sign-not-work/m-p/376288#M140266 2012-08-09T09:00:47Z