topic Re: Issue while Calculation sub total in pivot chart in QlikView https://community.qlik.com/t5/QlikView/Issue-while-Calculation-sub-total-in-pivot-chart/m-p/1397734#M812493 <HTML><HEAD></HEAD><BODY><P>What is your expression here? Use <STRONG>Sum(Aggr(Expression, YearMonth))</STRONG></P></BODY></HTML> Fri, 22 Sep 2017 13:13:14 GMT sunny_talwar 2017-09-22T13:13:14Z Issue while Calculation sub total in pivot chart https://community.qlik.com/t5/QlikView/Issue-while-Calculation-sub-total-in-pivot-chart/m-p/1397733#M812492 <HTML><HEAD></HEAD><BODY><P>Hey Friends,</P><P></P><P>I am unable to calculate correct Subtotal for expression having one dimension called YearMonth.</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&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;}" style="width: 151px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">YearMonth</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">WI Revenue</TH></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201704</TD><TD align="right" class="xl66" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,748</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201705</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,948</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201706</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,985</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201707</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">2,177</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201708</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,872</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201709</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,783</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201710</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,829</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201711</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,721</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201712</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,824</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201801</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,837</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201802</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,667</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">201803</TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1,832</TD></TR><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Total</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</TH></TR></TBODY></TABLE><P></P><P>I tried using Dimensionaly() to get the total but still i m unable to derive the total nos.</P><P>Could you guys please help me on this.</P><P></P><P>Thanks &amp; Regards,</P><P>Girish Chhatani@</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Issue-while-Calculation-sub-total-in-pivot-chart/m-p/1397733#M812492 Anonymous 2020-11-25T16:16:04Z Re: Issue while Calculation sub total in pivot chart https://community.qlik.com/t5/QlikView/Issue-while-Calculation-sub-total-in-pivot-chart/m-p/1397734#M812493 <HTML><HEAD></HEAD><BODY><P>What is your expression here? Use <STRONG>Sum(Aggr(Expression, YearMonth))</STRONG></P></BODY></HTML> Fri, 22 Sep 2017 13:13:14 GMT https://community.qlik.com/t5/QlikView/Issue-while-Calculation-sub-total-in-pivot-chart/m-p/1397734#M812493 sunny_talwar 2017-09-22T13:13:14Z