topic Bar graphs in QlikView

Bar graphs

Fri, 22 Apr 2011 13:59:42 GMT

Is there a way to NOT have a stacked bar graph when you have two or more expressions? I am trying to express my actual vs budget by month, but the bar keeps stacking, I need to present the bars side by side?

Thanx

Bar graphs

erichshiino — Fri, 22 Apr 2011 14:48:18 GMT

on the bar chart, go to properties -> Style tab and set subtype to stacked.

You could also change your chart to combo chart (on the general tab) and then on the expressions tab change some of the expresions to bar and others to symbols or lines.

Rgds,

Bar graphs

Fri, 22 Apr 2011 15:00:08 GMT

Thanx for the info. Unfortunately, when I have only two expressions the tool doesnt allow me to change styles....both grouped and stacked yield the same outcome...a stacked bar. The goal is to not have them be stacked.

SV:Re: Bar graphs

ToniKautto — Fri, 22 Apr 2011 15:20:10 GMT

Please attach a sample QVW of your app, so that it is possible to see exactly what settings and expressions you are running.

SV:Re: Bar graphs

Fri, 22 Apr 2011 15:28:01 GMT

See attached... the goal is to not have the bars stacked but have them side by side.

SV:Re: SV:Re: Bar graphs

ToniKautto — Fri, 22 Apr 2011 16:31:05 GMT

A quick way to solve this could be to remove the dimensions and add a new Calculated dimension as below;

=PostYM & '' & [Division Desc]

SV:Re: SV:Re: Bar graphs

Fri, 22 Apr 2011 16:59:10 GMT

Thank you...that worked!