topic Re: sum subtotal in QlikView https://community.qlik.com/t5/QlikView/sum-subtotal/m-p/20256#M780761 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>Sum(TOTAL &lt;Batch&gt; Inspected)</STRONG></P></BODY></HTML> Wed, 11 Apr 2018 14:57:36 GMT sunny_talwar 2018-04-11T14:57:36Z sum subtotal https://community.qlik.com/t5/QlikView/sum-subtotal/m-p/20255#M780760 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P>Below is my table</P><P>Bactch, Package ID, Inspected, Failed are all brought in from source data</P><P></P><P>I need to calculate for each batch the batch total </P><P></P><P>I cannot work out how to acheive this</P><P></P><P>any help or guidance would be gratefully appreciated</P><P></P><P></P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" 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"><STRONG>Batch</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Package ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Inspected</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Failed</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Batch Total</STRONG></TH></TR><TR><TD style="padding: 2px;">ABC123</TD><TD style="padding: 2px;">A24</TD><TD style="padding: 2px;">8011</TD><TD style="padding: 2px;">223</TD><TD style="padding: 2px;">23673 (=sum(Inspected for Batch))</TD></TR><TR><TD style="padding: 2px;">ABC123</TD><TD style="padding: 2px;">A25</TD><TD style="padding: 2px;">6897</TD><TD style="padding: 2px;">135</TD><TD style="padding: 2px;">23673</TD></TR><TR><TD style="padding: 2px;">ABC123</TD><TD style="padding: 2px;">A26</TD><TD style="padding: 2px;">8765</TD><TD style="padding: 2px;">198</TD><TD style="padding: 2px;">23673</TD></TR><TR><TD style="padding: 2px;">ABC124</TD><TD style="padding: 2px;">Z22</TD><TD style="padding: 2px;">2056</TD><TD style="padding: 2px;">22</TD><TD style="padding: 2px;">6711</TD></TR><TR><TD style="padding: 2px;">ABC124</TD><TD style="padding: 2px;">Y677</TD><TD style="padding: 2px;">3057</TD><TD style="padding: 2px;">23</TD><TD style="padding: 2px;">6711</TD></TR><TR><TD style="padding: 2px;">ABC124</TD><TD style="padding: 2px;">T567</TD><TD style="padding: 2px;">1598</TD><TD style="padding: 2px;">98</TD><TD style="padding: 2px;">6711</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/sum-subtotal/m-p/20255#M780760 spikenaylor1 2020-11-25T16:16:04Z Re: sum subtotal https://community.qlik.com/t5/QlikView/sum-subtotal/m-p/20256#M780761 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>Sum(TOTAL &lt;Batch&gt; Inspected)</STRONG></P></BODY></HTML> Wed, 11 Apr 2018 14:57:36 GMT https://community.qlik.com/t5/QlikView/sum-subtotal/m-p/20256#M780761 sunny_talwar 2018-04-11T14:57:36Z Re: sum subtotal https://community.qlik.com/t5/QlikView/sum-subtotal/m-p/20257#M780763 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P>very easy and simple</P><P>regards</P></BODY></HTML> Wed, 11 Apr 2018 15:01:39 GMT https://community.qlik.com/t5/QlikView/sum-subtotal/m-p/20257#M780763 spikenaylor1 2018-04-11T15:01:39Z