topic Re: Total behind each period. bar chart in QlikView https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388466#M514043 <HTML><HEAD></HEAD><BODY><P>Hi Pablo,</P><P></P><P>Find attached a solution for your problem.</P><P></P><P>Regards</P><P>Youseef</P></BODY></HTML> Thu, 21 Sep 2017 09:35:51 GMT YoussefBelloum 2017-09-21T09:35:51Z Total below each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388464#M514041 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>¿is there any way to show the total of each period below of each period?</P><P></P><P>thank you</P><P></P><P><IMG __jive_id="177271" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177271_Capture.PNG" style="height: 285px; width: 620px;" /></P></BODY></HTML> Thu, 21 Sep 2017 09:16:28 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388464#M514041 Anonymous 2017-09-21T09:16:28Z Re: Total behind each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388465#M514042 <HTML><HEAD></HEAD><BODY><P>If you have latest qv version, you might be able to see :</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177278_Capture.JPG" style="height: auto;" /></P><P>in presentation tab of the chart properties. Enable 'Stll Show Total on Top'.</P></BODY></HTML> Thu, 21 Sep 2017 09:21:34 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388465#M514042 tresB 2017-09-21T09:21:34Z Re: Total behind each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388466#M514043 <HTML><HEAD></HEAD><BODY><P>Hi Pablo,</P><P></P><P>Find attached a solution for your problem.</P><P></P><P>Regards</P><P>Youseef</P></BODY></HTML> Thu, 21 Sep 2017 09:35:51 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388466#M514043 YoussefBelloum 2017-09-21T09:35:51Z Re: Total behind each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388467#M514044 <HTML><HEAD></HEAD><BODY><P>i am sorry i mean below each period i want the total of the period</P></BODY></HTML> Thu, 21 Sep 2017 10:38:09 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388467#M514044 Anonymous 2017-09-21T10:38:09Z Re: Total behind each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388468#M514045 <HTML><HEAD></HEAD><BODY><P>replace Date dimension with a calculated Dimension</P><P></P><P><STRONG>=AGGR(Date &amp; chr(10) &amp;sum(Sales) , Date)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>you can also add Num() formatting</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><STRONG style="font-size: 13.3333px;">=AGGR(Date &amp; chr(10) &amp;NUM(sum(Sales),'#,###') , Date)</STRONG></STRONG></P></BODY></HTML> Thu, 21 Sep 2017 11:20:54 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388468#M514045 vinieme12 2017-09-21T11:20:54Z Re: Total behind each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388469#M514046 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i don´t see the total by date.</P><P></P><P>i attach the file with the dimension calculated.</P></BODY></HTML> Thu, 21 Sep 2017 13:51:54 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388469#M514046 Anonymous 2017-09-21T13:51:54Z Re: Total behind each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388470#M514047 <HTML><HEAD></HEAD><BODY><P>Please find the attached file. Hope it helps</P><P>Your calculated dimension should be below</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AGGR</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;"> &amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">chr</SPAN><SPAN style="font-size: 8pt;">(10) &amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">),'#.##0') , </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Thu, 21 Sep 2017 14:59:41 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388470#M514047 krishnacbe 2017-09-21T14:59:41Z Re: Total below each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388471#M514048 <HTML><HEAD></HEAD><BODY><P>i don´t see the totals</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177315_Capture.PNG" style="height: 312px; width: 620px;" /></P></BODY></HTML> Thu, 21 Sep 2017 15:14:51 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388471#M514048 Anonymous 2017-09-21T15:14:51Z Re: Total below each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388472#M514049 <HTML><HEAD></HEAD><BODY><P>the Code is not working in your copy? I am able to view in which I have attached.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177316_Capture.PNG" style="width: 620px; height: 202px;" /></P></BODY></HTML> Thu, 21 Sep 2017 15:22:00 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388472#M514049 krishnacbe 2017-09-21T15:22:00Z Re: Total below each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388473#M514050 <HTML><HEAD></HEAD><BODY><P>What about this ?</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177325_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 21 Sep 2017 15:50:00 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388473#M514050 antoniotiman 2017-09-21T15:50:00Z Re: Total below each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388474#M514051 <HTML><HEAD></HEAD><BODY><P>it´s perfect!!!</P><P></P><P>¿can you send me the file?</P></BODY></HTML> Thu, 21 Sep 2017 19:58:41 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388474#M514051 Anonymous 2017-09-21T19:58:41Z Re: Total below each period. bar chart https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388475#M514052 <HTML><HEAD></HEAD><BODY><P>See Attachment.</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Thu, 21 Sep 2017 21:08:38 GMT https://community.qlik.com/t5/QlikView/Total-below-each-period-bar-chart/m-p/1388475#M514052 antoniotiman 2017-09-21T21:08:38Z