topic Re: How to show grand total in trellis chart ? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-grand-total-in-trellis-chart/m-p/768934#M273097 <HTML><HEAD></HEAD><BODY><P>The best way to do this, add calculated dimension. Something like below,</P><P></P><P>=STATE&amp;Chr(10)&amp;'Total Volume='&amp;Aggr(Sum(VOLUME),STATE)</P><P></P><P><IMG alt="legend.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/70517_legend.PNG.png" /></P></BODY></HTML> Wed, 05 Nov 2014 06:13:05 GMT Anonymous 2014-11-05T06:13:05Z How to show grand total in trellis chart ? https://community.qlik.com/t5/QlikView/How-to-show-grand-total-in-trellis-chart/m-p/768932#M273095 <HTML><HEAD></HEAD><BODY><P>Hi, I am looking for solution to show grand total of legends in each charts shown in trellis</P><P></P><P>Sample Data:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD height="20" width="64">STATE</TD><TD width="64">CITY</TD><TD width="64">VOLUME</TD></TR><TR><TD height="20">MH</TD><TD>PN</TD><TD align="right">100</TD></TR><TR><TD height="20">MH</TD><TD>MUM</TD><TD align="right">200</TD></TR><TR><TD height="20">KN</TD><TD>BN</TD><TD align="right">900</TD></TR><TR><TD height="20">KN</TD><TD>TN</TD><TD align="right">800</TD></TR></TBODY></TABLE><P></P><P>Output:&nbsp; Please see the attachment, output should have a trellis and Grand Total of legends.</P></BODY></HTML> Wed, 05 Nov 2014 05:21:25 GMT https://community.qlik.com/t5/QlikView/How-to-show-grand-total-in-trellis-chart/m-p/768932#M273095 2014-11-05T05:21:25Z Re: How to show grand total in trellis chart ? https://community.qlik.com/t5/QlikView/How-to-show-grand-total-in-trellis-chart/m-p/768933#M273096 <HTML><HEAD></HEAD><BODY><P>Try chart properties-&gt;Presentation-&gt;Show numbers in legend(Check box)</P></BODY></HTML> Wed, 05 Nov 2014 05:52:18 GMT https://community.qlik.com/t5/QlikView/How-to-show-grand-total-in-trellis-chart/m-p/768933#M273096 vardhancse 2014-11-05T05:52:18Z Re: How to show grand total in trellis chart ? https://community.qlik.com/t5/QlikView/How-to-show-grand-total-in-trellis-chart/m-p/768934#M273097 <HTML><HEAD></HEAD><BODY><P>The best way to do this, add calculated dimension. Something like below,</P><P></P><P>=STATE&amp;Chr(10)&amp;'Total Volume='&amp;Aggr(Sum(VOLUME),STATE)</P><P></P><P><IMG alt="legend.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/70517_legend.PNG.png" /></P></BODY></HTML> Wed, 05 Nov 2014 06:13:05 GMT https://community.qlik.com/t5/QlikView/How-to-show-grand-total-in-trellis-chart/m-p/768934#M273097 Anonymous 2014-11-05T06:13:05Z