topic display subtotals in a trellis bar chart in QlikView https://community.qlik.com/t5/QlikView/display-subtotals-in-a-trellis-bar-chart/m-p/677304#M537740 <HTML><HEAD></HEAD><BODY><P>In a trellis bar chart, is it possible to insert totals in each panel, as I've indicated below ?</P><P></P><P></P><P></P><P><IMG alt="trellis.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68446_trellis.PNG.png" /></P></BODY></HTML> Tue, 07 Oct 2014 21:14:38 GMT gerrycastellino 2014-10-07T21:14:38Z display subtotals in a trellis bar chart https://community.qlik.com/t5/QlikView/display-subtotals-in-a-trellis-bar-chart/m-p/677304#M537740 <HTML><HEAD></HEAD><BODY><P>In a trellis bar chart, is it possible to insert totals in each panel, as I've indicated below ?</P><P></P><P></P><P></P><P><IMG alt="trellis.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68446_trellis.PNG.png" /></P></BODY></HTML> Tue, 07 Oct 2014 21:14:38 GMT https://community.qlik.com/t5/QlikView/display-subtotals-in-a-trellis-bar-chart/m-p/677304#M537740 gerrycastellino 2014-10-07T21:14:38Z Re: display subtotals in a trellis bar chart https://community.qlik.com/t5/QlikView/display-subtotals-in-a-trellis-bar-chart/m-p/677305#M537742 <HTML><HEAD></HEAD><BODY><P>Hello Gerry,</P><P>it is not possible to do it on a Bar chart Trelli...However, i was facing the same challenge last week and i find a way to avoid this problem and to have a total within the bar chart. see the image.</P><P></P><P><IMG alt="2015-10-07_15h05_47.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101275_2015-10-07_15h05_47.png" style="width: 620px; height: 401px;" /></P><P></P><P>You see the yellow figure <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> it is a trick. i have created a TEXT OBJECT with a formula in it, and i have set the color to transparent. therefore, i can put it on the top of the Bar Chart Trelli.</P><P></P><P><IMG alt="2015-10-07_15h18_04.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/101288_2015-10-07_15h18_04.png" style="height: auto;" /></P><P>Hope this helps even if it was a long time ago.</P><P>Best</P><P>JP</P></BODY></HTML> Wed, 07 Oct 2015 13:20:20 GMT https://community.qlik.com/t5/QlikView/display-subtotals-in-a-trellis-bar-chart/m-p/677305#M537742 2015-10-07T13:20:20Z