Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Unstacking a Bar Chart

I have a graph with two expressions (sun of actual and sum of Budget) graphed by month and category. I would like to represent the actual and budget as side by side bares but Qlikview only stacks the data. Is there wa way to have the interface not stack them? In style no matter what is selected (grouped or stacked) they are always stacked.

Any insight would be greatly appreciated.

Thanx

13 Replies
erich_shiino
Honored Contributor

Unstacking a Bar Chart

If your x-axis is set as continuos (on the axes tab) then the only possibility is to have stacked bars. Otherwise, (if you use them side by side) would mean that they are not in the same point in the axis (in time, for example)

You should disable the continuous x-axis or use another approach, for example on a combo chart, use one expression as a bar and another one as a line or a symbol.

Hope this helps,


Erich

Not applicable

Unstacking a Bar Chart

Unfortunately, they need to be in the same point and continous is disabled but they are stacked......there has to be a way to unstack....

dreamer78692
Contributor

Unstacking a Bar Chart

Hi,

Could someone please answer this question it is really important.

Kind Regards,

Razak

sivarajs
Valued Contributor II

Unstacking a Bar Chart

Hi,

How you are representing your dimension(group or seperate dim)

Sivaraj S

sivarajs
Valued Contributor II

Unstacking a Bar Chart

can you attach your sample file

Sivaraj S

dreamer78692
Contributor

Unstacking a Bar Chart

Hi,

I have the following dimensions,

EffectiveDate

Factor1 - Expression1

Factor2 - Expression2

Now EffectiveDate is on the x-axis, which is correct, the problem is I want a bar chart with Factor1 and Factor2 side-by-side compared to each another for different expressions. This works for other graphs like the line graph and combo graph, but for some reason it only shows a stacked bar graph when you use the bar chart.

Your Help will Really be Appreciated.

Kind Regards,

Razak

Not applicable

Re: Unstacking a Bar Chart

Hi,

I think you create a new bar chart (without copy from any source).Then apply your dimension and expression.

Thanks and Regards

Sovan Naskar

Not applicable

Re: Unstacking a Bar Chart

I think I got your issue, but if you can provide a example app, then I may give you the correct solution.

erich_shiino
Honored Contributor

Unstacking a Bar Chart

Hi, Razak

This result is a bit strainge, but based on you statement: "it only shows a stacked bar graph when you use the bar chart"

You can set the chart to be a combo chart and set all the expressions to be bars on the expression tab

Hope this helps,

Erich

Community Browser