topic Sum Only Expression Help! in QlikView https://community.qlik.com/t5/QlikView/Sum-Only-Expression-Help/m-p/257669#M495880 <HTML><HEAD></HEAD><BODY><P>Brian, you could use a sum(if()) for this</P><P></P><P>=sum( if([Contract Type] = 'Regional', Value))</P><P></P><P>or equivalent, but better performing a set expression</P><P>=sum( {&lt;[Contract Type]={Regional}&gt;} Value)</P><P></P><P>Just put this expression in a chart object, e.g. a text box.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Mon, 06 Feb 2012 19:04:01 GMT swuehl 2012-02-06T19:04:01Z Sum Only Expression Help! https://community.qlik.com/t5/QlikView/Sum-Only-Expression-Help/m-p/257668#M495879 <HTML><HEAD></HEAD><BODY><P>Hi gang, i need your help. I need to sum only regional contracts. I have a listing of contracts, and some of them are tagged as "regional." How can i sum only regional contracts using an expression?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Vendor</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Contract Type</STRONG></SPAN></TH></TR><TR><TD>Ricks' Car</TD><TD>$10</TD><TD>Regional</TD></TR><TR><TD>Jim Auto</TD><TD>$55</TD><TD>Regional</TD></TR><TR><TD>J&amp;J taxi</TD><TD>$5</TD><TD>Local</TD></TR></TBODY></TABLE><P></P><P>the answer would be $65 (Ricks and Jims total)</P><P></P><P>Regards,</P><P>Brian </P></BODY></HTML> Mon, 06 Feb 2012 18:45:39 GMT https://community.qlik.com/t5/QlikView/Sum-Only-Expression-Help/m-p/257668#M495879 2012-02-06T18:45:39Z Sum Only Expression Help! https://community.qlik.com/t5/QlikView/Sum-Only-Expression-Help/m-p/257669#M495880 <HTML><HEAD></HEAD><BODY><P>Brian, you could use a sum(if()) for this</P><P></P><P>=sum( if([Contract Type] = 'Regional', Value))</P><P></P><P>or equivalent, but better performing a set expression</P><P>=sum( {&lt;[Contract Type]={Regional}&gt;} Value)</P><P></P><P>Just put this expression in a chart object, e.g. a text box.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Mon, 06 Feb 2012 19:04:01 GMT https://community.qlik.com/t5/QlikView/Sum-Only-Expression-Help/m-p/257669#M495880 swuehl 2012-02-06T19:04:01Z