topic Re: Partial sum value in a pivot table in QlikView https://community.qlik.com/t5/QlikView/Partial-sum-value-in-a-pivot-table/m-p/446307#M561403 <HTML><HEAD></HEAD><BODY><P>It works (and il was so easy ...)</P><P></P><P>Thanks a lot.</P><P></P><P>Regards</P><P></P><P>Corrado</P></BODY></HTML> Fri, 15 Mar 2013 17:28:54 GMT cmatcovich 2013-03-15T17:28:54Z Partial sum value in a pivot table https://community.qlik.com/t5/QlikView/Partial-sum-value-in-a-pivot-table/m-p/446305#M561401 <HTML><HEAD></HEAD><BODY><P>Hi everibody,</P><P></P><P>I need an expression to calculate a partial percentage (percentage on a subtotal) in a pivot table like this:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 320px;"><TBODY><TR><TD class="xl63" height="20" width="64">Dim1</TD><TD class="xl63" style="border-left: none;" width="64">Dim2</TD><TD class="xl63" style="border-left: none;" width="64">Sum(Value)</TD><TD class="xl63" style="border-left: none;" width="64">SumT</TD><TD class="xl63" style="border-left: none;" width="64">PartPerc</TD></TR><TR><TD class="xl64" height="80" rowspan="4" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">AA</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">17%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none; border-left: none;">AB</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">33%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none; border-left: none;">AC</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">50%</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;">Total</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">6</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl64" height="80" rowspan="4" style="border-top: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">BA</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">60</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">17%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none; border-left: none;">BB</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">60</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">33%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none; border-left: none;">BC</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">60</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">50%</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;">Total</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">60</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Total</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">66</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P>I tried with this SumT expression:</P><P></P><P><EM>sum(agg<SPAN style="font-size: 10pt;">r(sum(Value), Dim1))</SPAN></EM></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P>but the correct value (6 or 60) is shown only in some cells and not in all of them.</P><P></P><P>Tanks for any suggestion!</P><P></P><P>Corrado Matcovich</P></BODY></HTML> Fri, 15 Mar 2013 17:15:47 GMT https://community.qlik.com/t5/QlikView/Partial-sum-value-in-a-pivot-table/m-p/446305#M561401 cmatcovich 2013-03-15T17:15:47Z Re: Partial sum value in a pivot table https://community.qlik.com/t5/QlikView/Partial-sum-value-in-a-pivot-table/m-p/446306#M561402 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Try with this:</P><P></P><P>sum(TOTAL &lt;Dim1&gt; Value)</P><P></P><P>See the attached.</P><P></P><P>Regards,</P><P>Ricardo</P></BODY></HTML> Fri, 15 Mar 2013 17:21:57 GMT https://community.qlik.com/t5/QlikView/Partial-sum-value-in-a-pivot-table/m-p/446306#M561402 2013-03-15T17:21:57Z Re: Partial sum value in a pivot table https://community.qlik.com/t5/QlikView/Partial-sum-value-in-a-pivot-table/m-p/446307#M561403 <HTML><HEAD></HEAD><BODY><P>It works (and il was so easy ...)</P><P></P><P>Thanks a lot.</P><P></P><P>Regards</P><P></P><P>Corrado</P></BODY></HTML> Fri, 15 Mar 2013 17:28:54 GMT https://community.qlik.com/t5/QlikView/Partial-sum-value-in-a-pivot-table/m-p/446307#M561403 cmatcovich 2013-03-15T17:28:54Z