https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835983#M532459 <HTML><HEAD></HEAD><BODY><P>I'm attempting to sum a value while conditionally excluding and including specific rows based on specific conditions.&nbsp; I generated the following expression using the set analysis wizard for QlikView:</P><P></P><P>=Sum({$&lt;Exchange-={'$(=OTC)','$(=NULL)','$(=PNK)'},[TR Adjusted Derivative Type]={'$(=Non-Derivative)'},[Trade to be Excluded?]={'$(=N)'}&gt;}[TR Notional Value])</P><P></P><P>There are no values returned.&nbsp; Something may be wrong with the syntax, but am unable to determine the problem.&nbsp; Any feedback would be helpful.</P></BODY></HTML> Mon, 27 Apr 2015 19:24:22 GMT 2015-04-27T19:24:22Z https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835983#M532459 <HTML><HEAD></HEAD><BODY><P>I'm attempting to sum a value while conditionally excluding and including specific rows based on specific conditions.&nbsp; I generated the following expression using the set analysis wizard for QlikView:</P><P></P><P>=Sum({$&lt;Exchange-={'$(=OTC)','$(=NULL)','$(=PNK)'},[TR Adjusted Derivative Type]={'$(=Non-Derivative)'},[Trade to be Excluded?]={'$(=N)'}&gt;}[TR Notional Value])</P><P></P><P>There are no values returned.&nbsp; Something may be wrong with the syntax, but am unable to determine the problem.&nbsp; Any feedback would be helpful.</P></BODY></HTML> Mon, 27 Apr 2015 19:24:22 GMT https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835983#M532459 2015-04-27T19:24:22Z https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835984#M532460 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Sum({$&lt;Exchange -= {'OTC','NULL','PNK'}, [TR Adjusted Derivative Type] = {'Non-Derivative'}, [Trade to be Excluded?] = {'N'}&gt;}[TR Notional Value])</STRONG></SPAN></P></BODY></HTML> Mon, 27 Apr 2015 20:02:21 GMT https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835984#M532460 sunny_talwar 2015-04-27T20:02:21Z https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835985#M532461 <HTML><HEAD></HEAD><BODY><P>Non-Derivative&nbsp;&nbsp; should probably&nbsp; be&nbsp; [Non-Derivative]&nbsp;&nbsp;&nbsp; ?</P><P></P><P>Are OTC, NULL PNK .... etc variables?&nbsp; If they are you will not need to use an equal sign...</P></BODY></HTML> Mon, 27 Apr 2015 20:03:46 GMT https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835985#M532461 petter 2015-04-27T20:03:46Z https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835986#M532462 <HTML><HEAD></HEAD><BODY><P>Sunni,</P><P></P><P>That worked.&nbsp; Thank you for your help.</P><P></P><P>Jeff</P></BODY></HTML> Mon, 27 Apr 2015 20:06:20 GMT https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835986#M532462 2015-04-27T20:06:20Z https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835987#M532463 <HTML><HEAD></HEAD><BODY><P>No problem. Glad I proved helpful.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Mon, 27 Apr 2015 20:07:25 GMT https://community.qlik.com/t5/QlikView/Calculating-Sum-while-excluding-and-including-conditions/m-p/835987#M532463 sunny_talwar 2015-04-27T20:07:25Z