topic How to add particular values sum in a column in QlikView https://community.qlik.com/t5/QlikView/How-to-add-particular-values-sum-in-a-column/m-p/756450#M269309 <HTML><HEAD></HEAD><BODY><P>Hi friends good day 2 all ,I'm having an issue with expressiopns sum.</P><P>Item is a column consists of values as A,B,C,D,E,Class.In pivot table taking dimension as Item and measures as peril,renewal .while sum it up the dimension Item we need&nbsp; to sum only(A+B+C+D+E) and not include Class in sum(exclude).can any one help on this to do in set analysis to exclude one value in a column..</P></BODY></HTML> Fri, 06 Feb 2015 05:27:51 GMT Anonymous 2015-02-06T05:27:51Z How to add particular values sum in a column https://community.qlik.com/t5/QlikView/How-to-add-particular-values-sum-in-a-column/m-p/756450#M269309 <HTML><HEAD></HEAD><BODY><P>Hi friends good day 2 all ,I'm having an issue with expressiopns sum.</P><P>Item is a column consists of values as A,B,C,D,E,Class.In pivot table taking dimension as Item and measures as peril,renewal .while sum it up the dimension Item we need&nbsp; to sum only(A+B+C+D+E) and not include Class in sum(exclude).can any one help on this to do in set analysis to exclude one value in a column..</P></BODY></HTML> Fri, 06 Feb 2015 05:27:51 GMT https://community.qlik.com/t5/QlikView/How-to-add-particular-values-sum-in-a-column/m-p/756450#M269309 Anonymous 2015-02-06T05:27:51Z Re: How to add particular values sum in a column https://community.qlik.com/t5/QlikView/How-to-add-particular-values-sum-in-a-column/m-p/756451#M269310 <HTML><HEAD></HEAD><BODY><P>Sum({&lt;Item-={'Class'}&gt;}measure)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Note '-' sign before '='</P></BODY></HTML> Fri, 06 Feb 2015 05:31:11 GMT https://community.qlik.com/t5/QlikView/How-to-add-particular-values-sum-in-a-column/m-p/756451#M269310 tresB 2015-02-06T05:31:11Z