topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1266342#M398896 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to write an expression with some filer and excluding other one</P><P>e.g. sum({&lt;Product={"=sum(Value)&gt;0"}&gt;}sales) here i need sales for product where value for each product should be grater than 0 and it should not affected by any other filter selection.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 15 Dec 2016 08:22:51 GMT vijetas42 2016-12-15T08:22:51Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1266342#M398896 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to write an expression with some filer and excluding other one</P><P>e.g. sum({&lt;Product={"=sum(Value)&gt;0"}&gt;}sales) here i need sales for product where value for each product should be grater than 0 and it should not affected by any other filter selection.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 15 Dec 2016 08:22:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1266342#M398896 vijetas42 2016-12-15T08:22:51Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1266343#M398897 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Add a 1 (one) in front to ignore all other selections: </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({<STRONG>1</STRONG>&lt;Product={"=sum(<STRONG>{1}</STRONG>Value)&gt;0"}&gt;}sales) </SPAN></P></BODY></HTML> Thu, 15 Dec 2016 08:34:21 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1266343#M398897 Gysbert_Wassenaar 2016-12-15T08:34:21Z