topic How do I make a set analysis statement with a not equal to &lt;&gt; field in QlikView https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206538#M62631 <HTML><HEAD></HEAD><BODY><P>Thank you, Jared. I appreciate the fast response time.</P><P>Venus</P></BODY></HTML> Fri, 08 Apr 2011 21:58:56 GMT 2011-04-08T21:58:56Z How do I make a set analysis statement with a not equal to <> field https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206534#M62627 <HTML><HEAD></HEAD><BODY><P>I want to exclude information from my totals in a chart. I want to set up a set analysis, stating if the field is not equal to ___ than sum the total cost. It does not like the not equal to symbols...</P><P>sum({&lt;Agent#&lt;&gt;{"55555555,54444444,53333333,52222222,51111111"}&gt;} Total)</P><P></P><P>Thank you,</P><P>Venus</P><P></P></BODY></HTML> Fri, 08 Apr 2011 20:55:06 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206534#M62627 2011-04-08T20:55:06Z How do I make a set analysis statement with a not equal to <> field https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206535#M62628 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P style="padding-left:30px;">sum({&lt;Agent#-={55555555,54444444,53333333,52222222,51111111}&gt;} Total)</P></BODY></HTML> Fri, 08 Apr 2011 21:04:37 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206535#M62628 johnw 2011-04-08T21:04:37Z How do I make a set analysis statement with a not equal to <> field https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206536#M62629 <HTML><HEAD></HEAD><BODY><P>Sum ( {$&lt; Agent# -= {'55555555,54444444,53333333,52222222,51111111''}&gt;} Total )</P><P>(would be the correct syntax I believe.. therefore the 'not equal to' would be '-=')</P><P>NOTE: QlikView 10 actually reports this as a bad syntax portion (underlines in red) yet will report "Expression OK" and work properly.</P><P></P><P>Best,</P><P></P><P>Jared</P></BODY></HTML> Fri, 08 Apr 2011 21:05:27 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206536#M62629 2011-04-08T21:05:27Z How do I make a set analysis statement with a not equal to <> field https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206537#M62630 <HTML><HEAD></HEAD><BODY><P>Thank you, John! It worked.</P></BODY></HTML> Fri, 08 Apr 2011 21:57:58 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206537#M62630 2011-04-08T21:57:58Z How do I make a set analysis statement with a not equal to <> field https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206538#M62631 <HTML><HEAD></HEAD><BODY><P>Thank you, Jared. I appreciate the fast response time.</P><P>Venus</P></BODY></HTML> Fri, 08 Apr 2011 21:58:56 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-a-set-analysis-statement-with-a-not-equal-to-lt-gt/m-p/206538#M62631 2011-04-08T21:58:56Z