topic Re: Total & Bar chart in QlikView https://community.qlik.com/t5/QlikView/Total-Bar-chart/m-p/1231896#M863350 <HTML><HEAD></HEAD><BODY><P>make a bar chart with no dimension and 4 expression, sum(Q1), sum(Q2), etc....</P><P></P><P>another option is to load your data with a crosstable&nbsp; load</P><P><A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P><P>and use the set analysis in the four expressions, something as</P><P>sum({$ &lt;Quarter={Q1}&gt;} Sales)</P></BODY></HTML> Fri, 23 Dec 2016 22:54:55 GMT maxgro 2016-12-23T22:54:55Z Total & Bar chart https://community.qlik.com/t5/QlikView/Total-Bar-chart/m-p/1231895#M863349 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>Probably, my questions was discussed many times, but spend more than 2 hours and cound not find the answer.</P><P>Siuation is very simple.</P><P>I have quaters in a row and sales number in columns like this:</P><P><SPAN style="font-size: 10pt;">Products&nbsp;&nbsp; Q1 Q2 Q3</SPAN></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp; 10&nbsp; ...&nbsp;&nbsp; </P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp; 40 ... </P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp; ...&nbsp; ...</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp; ... ...</P><P></P><P>So, what I'd like to do is a bar chart with total amount for all products per quarter.</P><P>Now the bar chart shows amount for each separate product.</P><P>How can I make just a total bur for Q1.</P><P>It is easy to do in excel, powerpoint, but I need to do this in Qlik.</P><P></P><P>Thanks a lot.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Total-Bar-chart/m-p/1231895#M863349 2020-11-25T16:16:04Z Re: Total & Bar chart https://community.qlik.com/t5/QlikView/Total-Bar-chart/m-p/1231896#M863350 <HTML><HEAD></HEAD><BODY><P>make a bar chart with no dimension and 4 expression, sum(Q1), sum(Q2), etc....</P><P></P><P>another option is to load your data with a crosstable&nbsp; load</P><P><A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P><P>and use the set analysis in the four expressions, something as</P><P>sum({$ &lt;Quarter={Q1}&gt;} Sales)</P></BODY></HTML> Fri, 23 Dec 2016 22:54:55 GMT https://community.qlik.com/t5/QlikView/Total-Bar-chart/m-p/1231896#M863350 maxgro 2016-12-23T22:54:55Z Re: Total & Bar chart https://community.qlik.com/t5/QlikView/Total-Bar-chart/m-p/1231897#M863351 <HTML><HEAD></HEAD><BODY><P>Like this ?&nbsp; PFA.</P></BODY></HTML> Sat, 24 Dec 2016 01:13:28 GMT https://community.qlik.com/t5/QlikView/Total-Bar-chart/m-p/1231897#M863351 jayanttibhe 2016-12-24T01:13:28Z Re: Total & Bar chart https://community.qlik.com/t5/QlikView/Total-Bar-chart/m-p/1231898#M863352 <HTML><HEAD></HEAD><BODY><P>Thanks a lot, guys! "Dummy" Dimension works!</P></BODY></HTML> Sat, 24 Dec 2016 11:26:56 GMT https://community.qlik.com/t5/QlikView/Total-Bar-chart/m-p/1231898#M863352 2016-12-24T11:26:56Z