topic Re: Qlik data vizualization for Pivot in Scalability https://community.qlik.com/t5/Scalability/Qlik-data-vizualization-for-Pivot/m-p/1404571#M1060 <HTML><HEAD></HEAD><BODY><P>Properties of chart - &gt; Presentation -&gt; subtotal on top</P><P></P><P>It should work.</P></BODY></HTML> Wed, 17 Jan 2018 12:22:37 GMT Anonymous 2018-01-17T12:22:37Z Qlik data vizualization for Pivot https://community.qlik.com/t5/Scalability/Qlik-data-vizualization-for-Pivot/m-p/1404569#M1058 <HTML><HEAD></HEAD><BODY><P>!@@Hi Team,</P><P>we have a below requirement</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD height="20" width="64">Region</TD><TD width="64">Channel</TD><TD align="right" class="xl63" width="64">17-Jul</TD><TD align="right" class="xl63" width="64">17-Jun</TD></TR><TR><TD height="20">South</TD><TD>Channel1</TD><TD align="right">0</TD><TD align="right">18</TD></TR><TR><TD height="20">West</TD><TD>Channel2</TD><TD align="right">12</TD><TD align="right">5</TD></TR><TR><TD height="20">East</TD><TD>Channel3</TD><TD align="right">13</TD><TD align="right">7</TD></TR><TR><TD height="20">NorthEast</TD><TD>Channel4</TD><TD align="right">18</TD><TD align="right">6</TD></TR><TR><TD height="20">North</TD><TD>Channel5</TD><TD align="right">19</TD><TD align="right">3</TD></TR><TR><TD height="20"></TD><TD>Total</TD><TD align="right">62</TD><TD align="right">39</TD></TR></TBODY></TABLE><P>Total is nothing but Sum of Jul-17 and Jun-17 aggregate.</P><P></P><P>The requirement is to show the Total somewhat like below</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="20" width="64">Region</TD><TD width="64">Channel</TD><TD align="right" class="xl65" width="64">17-Jul</TD><TD align="right" class="xl65" width="64">18-Jun</TD></TR><TR><TD height="20">Total</TD><TD></TD><TD align="right">62</TD><TD align="right">39</TD></TR><TR><TD height="20">South</TD><TD>Channel1</TD><TD align="right">0</TD><TD align="right">18</TD></TR><TR><TD height="20">West</TD><TD>Channel2</TD><TD align="right">12</TD><TD align="right">5</TD></TR><TR><TD height="20">East</TD><TD>Channel3</TD><TD align="right">13</TD><TD align="right">7</TD></TR><TR><TD height="20">NorthEast</TD><TD>Channel4</TD><TD align="right">18</TD><TD align="right">6</TD></TR><TR><TD height="20">North</TD><TD>Channel5</TD><TD align="right">19</TD><TD align="right"><P>3</P></TD></TR></TBODY></TABLE><P>Please note, we tried using partialsum, that failed when there are null values or missing valus, whole data becomes null in that case. Could you please see if that is feasible.</P></BODY></HTML> Thu, 30 Nov 2017 12:48:43 GMT https://community.qlik.com/t5/Scalability/Qlik-data-vizualization-for-Pivot/m-p/1404569#M1058 Anonymous 2017-11-30T12:48:43Z Re: Qlik data vizualization for Pivot https://community.qlik.com/t5/Scalability/Qlik-data-vizualization-for-Pivot/m-p/1404570#M1059 <HTML><HEAD></HEAD><BODY><P>any thought please</P></BODY></HTML> Fri, 01 Dec 2017 04:52:27 GMT https://community.qlik.com/t5/Scalability/Qlik-data-vizualization-for-Pivot/m-p/1404570#M1059 Anonymous 2017-12-01T04:52:27Z Re: Qlik data vizualization for Pivot https://community.qlik.com/t5/Scalability/Qlik-data-vizualization-for-Pivot/m-p/1404571#M1060 <HTML><HEAD></HEAD><BODY><P>Properties of chart - &gt; Presentation -&gt; subtotal on top</P><P></P><P>It should work.</P></BODY></HTML> Wed, 17 Jan 2018 12:22:37 GMT https://community.qlik.com/t5/Scalability/Qlik-data-vizualization-for-Pivot/m-p/1404571#M1060 Anonymous 2018-01-17T12:22:37Z