topic Re: sum TOTAL with criteria in QlikView https://community.qlik.com/t5/QlikView/sum-TOTAL-with-criteria/m-p/1107744#M463564 <HTML><HEAD></HEAD><BODY><P>=Sum(TOTAL&lt;Contract&gt; Amount)</P></BODY></HTML> Fri, 24 Jun 2016 09:58:59 GMT swuehl 2016-06-24T09:58:59Z sum TOTAL with criteria https://community.qlik.com/t5/QlikView/sum-TOTAL-with-criteria/m-p/1107743#M463563 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm looking for a formula to calculate the total amount of the contract. The input data is as follows:</P><P>- Contract: (Dimension)</P><P>- Date; (Dimension)</P><P>- Amount: sum(Amount)</P><P>- Total Amount: ???</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Contract</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Total Amount</STRONG></TH></TR><TR><TD style="padding: 2px;">X</TD><TD style="padding: 2px;">1/1/2016</TD><TD style="padding: 2px;">15.000</TD><TD style="padding: 2px;">30.000</TD></TR><TR><TD style="padding: 2px;">X</TD><TD style="padding: 2px;">5/1/2016</TD><TD style="padding: 2px;">10.000</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">30.000</SPAN></TD></TR><TR><TD style="padding: 2px;">X</TD><TD style="padding: 2px;">6/1/2016</TD><TD style="padding: 2px;">5.000</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">30.000</SPAN></TD></TR><TR><TD style="padding: 2px;">Y</TD><TD style="padding: 2px;">2/1/2016</TD><TD style="padding: 2px;">25.000</TD><TD style="padding: 2px;">45.000</TD></TR><TR><TD style="padding: 2px;">Y</TD><TD style="padding: 2px;">4/1/2016</TD><TD style="padding: 2px;">20.000</TD><TD style="padding: 2px;">45.000</TD></TR><TR><TD>Z</TD><TD>1/1/2016</TD><TD>35.000</TD><TD>35.000</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 24 Jun 2016 09:49:54 GMT https://community.qlik.com/t5/QlikView/sum-TOTAL-with-criteria/m-p/1107743#M463563 tomhovens 2016-06-24T09:49:54Z Re: sum TOTAL with criteria https://community.qlik.com/t5/QlikView/sum-TOTAL-with-criteria/m-p/1107744#M463564 <HTML><HEAD></HEAD><BODY><P>=Sum(TOTAL&lt;Contract&gt; Amount)</P></BODY></HTML> Fri, 24 Jun 2016 09:58:59 GMT https://community.qlik.com/t5/QlikView/sum-TOTAL-with-criteria/m-p/1107744#M463564 swuehl 2016-06-24T09:58:59Z