Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Charts w/Stacked Bars

I'm creating a chart with two dimensions (Year and Month) with multiple expressions (Revenue, Margin, Expenses, etc.) and I've chosen to use a bar chart object.  The result chart is stacking the bar with the multiple expression values.  Is there any way to avoid this while keeping the multiple dimensions?  Thank you in advance.

1 Solution

Accepted Solutions
joris_lansdaal
Creator
Creator

Do you use those two dimensions because you want to see YearMonth like Jan 2016, Feb 2016 etc.

create a YearMonth in your script and use that as a single dimension.

View solution in original post

8 Replies
oknotsen
Master III
Master III

Are you talking about QlikView or Qlik Sense (as you did not post this in the correct category)?

Let me know so we can move it to the right spot.

May you live in interesting times!
Not applicable
Author

I'm using QlikView v11.2

joris_lansdaal
Creator
Creator

Can you give a printscreen of your graph? thanks

santiago_respane
Specialist
Specialist

Hi Steven,

in chart properties, in the Style tab, you have the option for subtype in which you can choose between stacked or grouped bar charts.

Please let me know if this is what you where looking for.

Kind regards,

Not applicable
Author

Hey Santiago,

I've already discovered and toyed with that option.  I've found that when using one dimension the style option works as I would anticipate; however, when throwing more dimensions at the chart, it automatically stacks the bar.  So, sorry, this does not resolve my issue.

Thank you,

Not applicable
Author

joris_lansdaal
Creator
Creator

Do you use those two dimensions because you want to see YearMonth like Jan 2016, Feb 2016 etc.

create a YearMonth in your script and use that as a single dimension.

Not applicable
Author

Sounds like good option.