topic Re: Problem with sum in listBox in QlikView https://community.qlik.com/t5/QlikView/Problem-with-sum-in-listBox/m-p/686082#M671561 <HTML><HEAD></HEAD><BODY><P>Aggr() seems resolving the problem. your help was very helpful, thank you.</P></BODY></HTML> Tue, 02 Sep 2014 08:51:38 GMT 2014-09-02T08:51:38Z Problem with sum in listBox https://community.qlik.com/t5/QlikView/Problem-with-sum-in-listBox/m-p/686079#M671558 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P><SPAN lang="en"><SPAN class="hps">In a list</SPAN><SPAN class="hps">Box</SPAN>, I want to <SPAN class="hps">calculate the sum of</SPAN> <SPAN class="hps">multiple entities</SPAN> <SPAN class="hps">based on</SPAN> <SPAN class="hps">the following formula:</SPAN> <BR /><SPAN class="atn hps"><STRONG><EM>if (</EM></STRONG></SPAN><STRONG><EM>X <SPAN class="hps">=</SPAN> <SPAN class="hps">200</SPAN> <SPAN class="hps">OR</SPAN> <SPAN lang="en"><SPAN class="hps">Y = </SPAN></SPAN><SPAN class="hps">381</SPAN>, sum <SPAN class="atn hps">(if (</SPAN>Z <SPAN class="hps">= 4</SPAN>, <SPAN class="hps">amount</SPAN>, 0)), 0) </EM></STRONG><BR />listBox <SPAN class="hps">does not work with</SPAN> <SPAN class="hps">SUM</SPAN>. <SPAN class="hps">while</SPAN> <SPAN class="hps">the same expression</SPAN> <SPAN class="hps">works well</SPAN> <SPAN class="hps">in another table in the same sheet</SPAN><SPAN class="hps">.</SPAN></SPAN></P></BODY></HTML> Tue, 02 Sep 2014 07:59:50 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-in-listBox/m-p/686079#M671558 2014-09-02T07:59:50Z Re: Problem with sum in listBox https://community.qlik.com/t5/QlikView/Problem-with-sum-in-listBox/m-p/686080#M671559 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can you not do your formula in the script and name it as a field?</P></BODY></HTML> Tue, 02 Sep 2014 08:03:38 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-in-listBox/m-p/686080#M671559 rido1421 2014-09-02T08:03:38Z Re: Problem with sum in listBox https://community.qlik.com/t5/QlikView/Problem-with-sum-in-listBox/m-p/686081#M671560 <HTML><HEAD></HEAD><BODY><P>You could achieve similar output with proper use of Aggr(). Try to share a sample qvw with sample data explaining expected output.</P></BODY></HTML> Tue, 02 Sep 2014 08:13:11 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-in-listBox/m-p/686081#M671560 tresB 2014-09-02T08:13:11Z Re: Problem with sum in listBox https://community.qlik.com/t5/QlikView/Problem-with-sum-in-listBox/m-p/686082#M671561 <HTML><HEAD></HEAD><BODY><P>Aggr() seems resolving the problem. your help was very helpful, thank you.</P></BODY></HTML> Tue, 02 Sep 2014 08:51:38 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-in-listBox/m-p/686082#M671561 2014-09-02T08:51:38Z