Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Cannot create grouped bar chart

I'm trying to create a grouped bar chart. I have the following sample data:

LOAD * INLINE [

    Country, Sales, Costs

    USA, 1000, 800

    UK, 800, 700

    Germany, 900, 1000

    Japan, 600, 400

];

I have set the style for the chart to be grouped, but it always shows stacked.  Screenshot of actual table and settings

in the properties. 

Chart.PNG.png

What am I missing?  I am running 11.2 r5 on Windows 7.   My forehead style is flat.

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Cannot create grouped bar chart

try to remove from dimensions tab

costs

sales

I did it in tour qvw, this is the result

bar.jpg

10 Replies
MVP
MVP

Re: Cannot create grouped bar chart

try the chart in the attachment and post your qvw if possible

Partner
Partner

Re: Cannot create grouped bar chart

Hi Steve.

I am also loaded the same data and its working fine for me.

bar_chart.png

Can you share your qvw file.

Not applicable

Re: Cannot create grouped bar chart

I am using the Personal Edition right now, but if you can view it, that would be great.

Thanks

MVP
MVP

Re: Cannot create grouped bar chart

try to remove from dimensions tab

costs

sales

I did it in tour qvw, this is the result

bar.jpg

jsaradhi
Valued Contributor

Re: Cannot create grouped bar chart

like Massimo said, you have sales and costs in your dimensions along with Country. removing the sales and costs from dimensions and leaving country alone as a dimension should take care of your issue.

SunilChauhan
Esteemed Contributor

Re: Cannot create grouped bar chart

Currentely you are using Sales in Dimension that why it showing stack chart.

use only coutry in dimension

move your sales to Expression

i mean

in dimension Country

and sales and Cost in Expression

hope this helps

Not applicable

Re: Cannot create grouped bar chart

Removing the costs and sales from the dimensions tab allowed me to change the appearance in the style tab to grouped, and the preview on the style tab then showed up as grouped, but that had no effect on the chart when the change was applied. However, creating a second chart Country as the only dimension created a grouped bar chart. Also, closing the document and reopening it caused the first chart to appear as grouped. I tried reloading the data before I closed and reopened the document, but that didn’t have any effect.

This seems like a bug to me.

Thanks to all for your very prompt help. The forum is awesome. Far superior to any other BI forum I have seen.

MVP
MVP

Re: Cannot create grouped bar chart

I tried the same thing,

- downloaded your doc

- removed two dimensions

and I still got the grouped bar chart without any problem

Reload, close, open, etc......always grouped

I have 11.20 SR5, perhaps a different version........?

Not applicable

Re: Cannot create grouped bar chart

I am using the Personal Edition, but I would not think that would cause the issue.

As of now, switching between grouped and stacked is now working properly. Adding the unneeded dimensions causes the

chart to switch to stacked, but removing them allows me to set it back to grouped. I can’t recreate my initial problem.

Thanks again.