topic SV:Not Equal to checking in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Not-Equal-to-checking-in-Set-Analysis/m-p/206551#M62638 <HTML><HEAD></HEAD><BODY><P>Thanks It worked the way I want...</P><P>And aso could you tell me how to check not null values... (like this -=null())</P></BODY></HTML> Fri, 17 Sep 2010 14:44:08 GMT 2010-09-17T14:44:08Z Not Equal to checking in Set Analysis https://community.qlik.com/t5/QlikView/Not-Equal-to-checking-in-Set-Analysis/m-p/206548#M62635 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Usually we use equal to in set analysis.</P><P>in my case</P><P>Status column =0 or 1 or anything (based on data)</P><P>I want to have all prioduct sales whose status &lt;&gt; 0 and ID=1</P><P>What is the syntax for that?</P><P></P></BODY></HTML> Fri, 17 Sep 2010 12:26:45 GMT https://community.qlik.com/t5/QlikView/Not-Equal-to-checking-in-Set-Analysis/m-p/206548#M62635 2010-09-17T12:26:45Z SV:Not Equal to checking in Set Analysis https://community.qlik.com/t5/QlikView/Not-Equal-to-checking-in-Set-Analysis/m-p/206549#M62636 <HTML><HEAD></HEAD><BODY><P>it would be something like:</P><P>sum( {&lt;status-={0}, ID={1}&gt;} sales)</P><P>note the -= for status</P></BODY></HTML> Fri, 17 Sep 2010 12:30:41 GMT https://community.qlik.com/t5/QlikView/Not-Equal-to-checking-in-Set-Analysis/m-p/206549#M62636 gandalfgray 2010-09-17T12:30:41Z SV:Not Equal to checking in Set Analysis https://community.qlik.com/t5/QlikView/Not-Equal-to-checking-in-Set-Analysis/m-p/206550#M62637 <HTML><HEAD></HEAD><BODY><P>and additional info ;</P><P>*if you use "-" before "=" like that sum( {&lt;status-={0}, ID={1}&gt;} sales) result will effect your choise</P><P>*if you use "-" after "=" like that sum( {&lt;status=-{0}, ID={1}&gt;} sales) result will not effect your choise ...</P></BODY></HTML> Fri, 17 Sep 2010 13:00:49 GMT https://community.qlik.com/t5/QlikView/Not-Equal-to-checking-in-Set-Analysis/m-p/206550#M62637 2010-09-17T13:00:49Z SV:Not Equal to checking in Set Analysis https://community.qlik.com/t5/QlikView/Not-Equal-to-checking-in-Set-Analysis/m-p/206551#M62638 <HTML><HEAD></HEAD><BODY><P>Thanks It worked the way I want...</P><P>And aso could you tell me how to check not null values... (like this -=null())</P></BODY></HTML> Fri, 17 Sep 2010 14:44:08 GMT https://community.qlik.com/t5/QlikView/Not-Equal-to-checking-in-Set-Analysis/m-p/206551#M62638 2010-09-17T14:44:08Z