topic Sum values except some range in QlikView https://community.qlik.com/t5/QlikView/Sum-values-except-some-range/m-p/1239938#M863569 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to sum values as below except for the numbers begins with '7'.</P><P>Cound you please help?</P><P>thank you.</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD class="xl69" height="20" width="64">Numbers</TD><TD class="xl69" width="64">Amount </TD></TR><TR><TD class="xl69" height="20">100</TD><TD class="xl69">200</TD></TR><TR><TD class="xl69" height="20">250</TD><TD class="xl69">600</TD></TR><TR><TD class="xl69" height="20">700</TD><TD class="xl69">100</TD></TR><TR><TD class="xl69" height="20">780</TD><TD class="xl69">50</TD></TR><TR><TD class="xl69" height="20">782</TD><TD class="xl69">750</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT fatihtomruk 2020-11-25T16:16:04Z Sum values except some range https://community.qlik.com/t5/QlikView/Sum-values-except-some-range/m-p/1239938#M863569 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to sum values as below except for the numbers begins with '7'.</P><P>Cound you please help?</P><P>thank you.</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD class="xl69" height="20" width="64">Numbers</TD><TD class="xl69" width="64">Amount </TD></TR><TR><TD class="xl69" height="20">100</TD><TD class="xl69">200</TD></TR><TR><TD class="xl69" height="20">250</TD><TD class="xl69">600</TD></TR><TR><TD class="xl69" height="20">700</TD><TD class="xl69">100</TD></TR><TR><TD class="xl69" height="20">780</TD><TD class="xl69">50</TD></TR><TR><TD class="xl69" height="20">782</TD><TD class="xl69">750</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-values-except-some-range/m-p/1239938#M863569 fatihtomruk 2020-11-25T16:16:04Z Re: Sum values except some range https://community.qlik.com/t5/QlikView/Sum-values-except-some-range/m-p/1239939#M863570 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Sum({&lt;Numbers <SPAN style="color: #ff0000;">-</SPAN>= {<SPAN style="color: #ff0000;">'7*'</SPAN>}&gt;} Amount)</STRONG></P></BODY></HTML> Tue, 27 Dec 2016 12:49:16 GMT https://community.qlik.com/t5/QlikView/Sum-values-except-some-range/m-p/1239939#M863570 sunny_talwar 2016-12-27T12:49:16Z Re: Sum values except some range https://community.qlik.com/t5/QlikView/Sum-values-except-some-range/m-p/1239940#M863571 <HTML><HEAD></HEAD><BODY><P><STRONG>Try</STRONG></P><P><STRONG>Sum({&lt;Numbers -= {'7*'}&gt;} Amount)</STRONG></P></BODY></HTML> Tue, 27 Dec 2016 13:18:50 GMT https://community.qlik.com/t5/QlikView/Sum-values-except-some-range/m-p/1239940#M863571 dsharmaqv 2016-12-27T13:18:50Z