topic Set analysis not equal in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-not-equal/m-p/962485#M953004 <HTML><HEAD></HEAD><BODY><P>Hi Guy's</P><P></P><P>I am trying to use the following set analysis but cant seem to get it right.</P><P></P><P>sum({&lt;[Lab Authorisation Type]= {'1'}, [Grower ID] -= {'77'}, [Grower ID] -= {'99'}, [Grower ID] -= {'100'}, [Grower ID] -= {'111'}&gt;} [Delivery DIS Mass Adjusted])</P><P></P><P><IMG alt="Untitled-1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/106407_Untitled-1.jpg" style="height: 296px; width: 620px;" /></P></BODY></HTML> Mon, 23 Nov 2015 11:14:45 GMT 2015-11-23T11:14:45Z Set analysis not equal https://community.qlik.com/t5/QlikView/Set-analysis-not-equal/m-p/962485#M953004 <HTML><HEAD></HEAD><BODY><P>Hi Guy's</P><P></P><P>I am trying to use the following set analysis but cant seem to get it right.</P><P></P><P>sum({&lt;[Lab Authorisation Type]= {'1'}, [Grower ID] -= {'77'}, [Grower ID] -= {'99'}, [Grower ID] -= {'100'}, [Grower ID] -= {'111'}&gt;} [Delivery DIS Mass Adjusted])</P><P></P><P><IMG alt="Untitled-1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/106407_Untitled-1.jpg" style="height: 296px; width: 620px;" /></P></BODY></HTML> Mon, 23 Nov 2015 11:14:45 GMT https://community.qlik.com/t5/QlikView/Set-analysis-not-equal/m-p/962485#M953004 2015-11-23T11:14:45Z Re: Set analysis not equal https://community.qlik.com/t5/QlikView/Set-analysis-not-equal/m-p/962486#M953005 <HTML><HEAD></HEAD><BODY><P>Only use one set modifier per field within a &lt;....&gt; pair.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;[Lab Authorisation Type]= {'1'}, [Grower ID] -= {'77','99','100','111'} &gt;} [Delivery DIS Mass Adjusted])</SPAN></P></BODY></HTML> Mon, 23 Nov 2015 16:57:46 GMT https://community.qlik.com/t5/QlikView/Set-analysis-not-equal/m-p/962486#M953005 swuehl 2015-11-23T16:57:46Z