Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 

Showing all brand sales in a single bar - in Barchart

Hi All,

Could you please help me out with the below requirement:

Brands.PNG Bars.PNG

I have five brands and their sales and qty as above.

Now, i would like to show sales of all the brands in a single bar with the values Sum(total Sales) = 27142

Is this possible in Qlikview or QlikSense?

Thanks in advance!!



Labels (1)
  • Chart

3 Replies
Partner - Master III
Partner - Master III

Yes it should be unless i am missing something (wrt your requirement)

Have you tried stack option?

Partner - Champion III
Partner - Champion III

Yes you can do it in both Qlik Sense and QlikView. But oddly enough you won't get the stacked option to select unless you have at least two dimensions. So in your case you will have to create an extra dimension which can be a constant not referring to a field as the first dimension and brand as the second dimension. You can enter =1 as the expression for the first dimension. Then you get to select stacked:

Here is how it looks like in both products:

2018-10-16 08_56_11-Window.png

2018-10-16 08_56_25-Window.png


Hi Petter,

Thanks for your post and it was a help full info.

In the bar chart, we can see X-axis legend as below which may gives confusion to users right, Can't we display only Brand on X-axis?


I have tried like changing the first dimension label to Brand and its finally displaying as below. Is there any other tricks?

New legend.PNG