topic Re: How to sum the bars in bar chart and show it as a single bar in QlikView https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894142#M988413 <HTML><HEAD></HEAD><BODY><P>HI Gaurav,</P><P></P><P>can you use a stacked chart in stead of grouped?</P><P></P><P>Andy</P></BODY></HTML> Fri, 17 Jul 2015 14:40:21 GMT awhitfield 2015-07-17T14:40:21Z How to sum the bars in bar chart and show it as a single bar https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894137#M988408 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I have a bar chart that shows sum of amount by department</P><P></P><P></P><P>it Shows sum of amount by&nbsp; department (in shows 10 bars of 10 different department) </P><P></P><P></P><P>I want a bar chart that displays a single bar</P></BODY></HTML> Fri, 17 Jul 2015 05:53:34 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894137#M988408 2015-07-17T05:53:34Z Re: How to sum the bars in bar chart and show it as a single bar https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894138#M988409 <HTML><HEAD></HEAD><BODY><P>Go to Style tab and select Subtype as Stacked</P></BODY></HTML> Fri, 17 Jul 2015 05:55:33 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894138#M988409 Anonymous 2015-07-17T05:55:33Z Re: How to sum the bars in bar chart and show it as a single bar https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894139#M988410 <HTML><HEAD></HEAD><BODY><P>PFA.</P></BODY></HTML> Fri, 17 Jul 2015 06:02:44 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894139#M988410 2015-07-17T06:02:44Z Re: How to sum the bars in bar chart and show it as a single bar https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894140#M988411 <HTML><HEAD></HEAD><BODY><P>You can try with the following expression:</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">all</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">revenue</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Fri, 17 Jul 2015 06:47:16 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894140#M988411 2015-07-17T06:47:16Z Re: How to sum the bars in bar chart and show it as a single bar https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894141#M988412 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use of stack type bar chart will be more suitable for you.</P><P></P><P>So that you can have a single bar against multiple departments with indicator of separate color for seperate department.</P><P></P><P>Hope this will be helpful for you.</P><P></P><P>--</P><P>Regards,</P><P>Prashant P Baste</P></BODY></HTML> Fri, 17 Jul 2015 06:51:03 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894141#M988412 prashantbaste 2015-07-17T06:51:03Z Re: How to sum the bars in bar chart and show it as a single bar https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894142#M988413 <HTML><HEAD></HEAD><BODY><P>HI Gaurav,</P><P></P><P>can you use a stacked chart in stead of grouped?</P><P></P><P>Andy</P></BODY></HTML> Fri, 17 Jul 2015 14:40:21 GMT https://community.qlik.com/t5/QlikView/How-to-sum-the-bars-in-bar-chart-and-show-it-as-a-single-bar/m-p/894142#M988413 awhitfield 2015-07-17T14:40:21Z