topic Re: Unstacking a Bar Chart in QlikView

Unstacking a Bar Chart

Fri, 17 Jun 2011 13:16:29 GMT

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

Unstacking a Bar Chart

erichshiino — Fri, 17 Jun 2011 13:25:38 GMT

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

Unstacking a Bar Chart

Fri, 17 Jun 2011 13:30:27 GMT

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

Unstacking a Bar Chart

Anonymous — Thu, 22 Mar 2012 07:50:13 GMT

Hi,

Could someone please answer this question it is really important.

Kind Regards,

Razak

Unstacking a Bar Chart

sivarajs — Thu, 22 Mar 2012 10:44:25 GMT

Hi,

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

Sivaraj S

Unstacking a Bar Chart

sivarajs — Thu, 22 Mar 2012 10:46:07 GMT

can you attach your sample file

Sivaraj S

Unstacking a Bar Chart

Anonymous — Fri, 23 Mar 2012 05:29:53 GMT

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

Re: Unstacking a Bar Chart

Fri, 23 Mar 2012 06:37:07 GMT

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

Re: Unstacking a Bar Chart

Fri, 23 Mar 2012 08:24:26 GMT

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

Unstacking a Bar Chart

erichshiino — Fri, 23 Mar 2012 17:12:09 GMT

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

Re: Unstacking a Bar Chart

Anonymous — Mon, 26 Mar 2012 06:28:07 GMT

Hi,

I have tried that, it seems to still give me a stacked bar graph.

I have made a sample file please look at it.

Kind Regards

Razak

Re: Unstacking a Bar Chart

Mon, 26 Mar 2012 06:56:40 GMT

hi Fuji,

the problem lies the way you are choosing your dimensions , i cant understant what you try

to achive by taking Effective Date ,A, B as dimension against Value1 , Value2 , if you realy want

to show values against these three dimensions just go and create a cyclic gruop and select dimension

i have checked it is showing stack chart only since you have taken all three dimsion together.

to create a cyclic group go to Settings->Document properties ->Group there create

a cyclic group and add in your chart.

Hope this hepls

Warm regards,

Anant Dubey

Re: Unstacking a Bar Chart

Mon, 26 Mar 2012 07:15:36 GMT

hi dreamer,

just go try using dimension as effective date , you will get two bars side be side,

the problem lies the way you are using dimensions Effective date,A,B

just use a cyclic group and you will get what you want.

regards,

Anant

Unstacking a Bar Chart

Anonymous — Mon, 26 Mar 2012 07:22:47 GMT

HI,

Thank You It Works!!!

Kind Regards

Razak