topic Replacing by set analysis? in QlikView https://community.qlik.com/t5/QlikView/Replacing-by-set-analysis/m-p/237789#M88783 <HTML><HEAD></HEAD><BODY><P>Something like this may work:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum({&lt;Dos_StatusId -= {1000,1001,1002,1003,1004,1006,1008,1009,1050,1051,1052,1126}&gt;} Sales)</PRE></BLOCKQUOTE><BR /><BR /> <P>That would only Sum values where Dos_StatusId is not in that list. Is that what you're looking for?</P></BODY></HTML> Fri, 12 Feb 2010 15:32:22 GMT 2010-02-12T15:32:22Z Replacing by set analysis? https://community.qlik.com/t5/QlikView/Replacing-by-set-analysis/m-p/237788#M88782 <HTML><HEAD></HEAD><BODY><P>Can i replace the if by a Set An?</P><P></P><P></P><P>if(match(Dos_StatusId,1000,1001,1002,1003,1004,1006,1008,1009,1050,1051,1052,1126)=0,......)</P><P></P><P>tnx</P><BR /><BR /></BODY></HTML> Fri, 12 Feb 2010 15:10:32 GMT https://community.qlik.com/t5/QlikView/Replacing-by-set-analysis/m-p/237788#M88782 timmy 2010-02-12T15:10:32Z Replacing by set analysis? https://community.qlik.com/t5/QlikView/Replacing-by-set-analysis/m-p/237789#M88783 <HTML><HEAD></HEAD><BODY><P>Something like this may work:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum({&lt;Dos_StatusId -= {1000,1001,1002,1003,1004,1006,1008,1009,1050,1051,1052,1126}&gt;} Sales)</PRE></BLOCKQUOTE><BR /><BR /> <P>That would only Sum values where Dos_StatusId is not in that list. Is that what you're looking for?</P></BODY></HTML> Fri, 12 Feb 2010 15:32:22 GMT https://community.qlik.com/t5/QlikView/Replacing-by-set-analysis/m-p/237789#M88783 2010-02-12T15:32:22Z