topic Re: Cannot create grouped bar chart in QlikView

Cannot create grouped bar chart

Wed, 05 Mar 2014 23:23:38 GMT

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.

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

Re: Cannot create grouped bar chart

maxgro — Wed, 05 Mar 2014 23:34:13 GMT

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

Re: Cannot create grouped bar chart

jsingh71 — Thu, 06 Mar 2014 10:50:34 GMT

Hi Steve.

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

Can you share your qvw file.

Re: Cannot create grouped bar chart

Thu, 06 Mar 2014 15:15:11 GMT

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

Thanks

Re: Cannot create grouped bar chart

maxgro — Thu, 06 Mar 2014 15:36:17 GMT

try to remove from dimensions tab

costs

sales

I did it in tour qvw, this is the result

Re: Cannot create grouped bar chart

Anonymous — Thu, 06 Mar 2014 15:55:38 GMT

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.

Re: Cannot create grouped bar chart

SunilChauhan — Thu, 06 Mar 2014 15:55:50 GMT

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

Re: Cannot create grouped bar chart

Thu, 06 Mar 2014 16:10:59 GMT

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.

Re: Cannot create grouped bar chart

maxgro — Thu, 06 Mar 2014 19:38:02 GMT

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........?

Re: Cannot create grouped bar chart

Thu, 06 Mar 2014 21:09:48 GMT

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.

Re: Cannot create grouped bar chart

maxgro — Thu, 06 Mar 2014 21:14:38 GMT

please, close the discussion marking corrrect or helpful answers if you feel like