topic Unstacking a bar chart in QlikView

Unstacking a bar chart

reshmakala — Tue, 23 Dec 2014 16:18:26 GMT

Hello all,

I have a bar chart with 3 dimensions enabled conditionally and 2 expressions. I want the chart to be an unstacked bar chart but it doesn't seem to work when I move from one dimension to other.

Example: In the file attached, there are two bars for two expressions. When I select the year, it displays the quarters and has stacked bars. Can I have unstacked bars even at Quarter and Month levels?

Thanks in advance.

Re: Unstacking a bar chart

Anonymous — Tue, 23 Dec 2014 16:34:31 GMT

Attached.

Re: Unstacking a bar chart

reshmakala — Tue, 23 Dec 2014 16:36:20 GMT

Thank you so much! Could you please explain what I was missing?

Update: I got it.. Thank you so much!!

Re: Unstacking a bar chart

jpapador — Tue, 23 Dec 2014 16:38:41 GMT

It looks like you want to keep the selected dimension as an active dimension but is there a reason you don't use a drill down group with a current selections box?

See Attached

Re: Unstacking a bar chart

reshmakala — Tue, 23 Dec 2014 16:42:34 GMT

Yes.. this was just an example. I had other dimensions that are not in hierarchy. and I wanted to display all the series of selections so I did not use drill down

Also am using this chart in an alternate state and drill downs are not working in alternate states. So I have to use conditional enabled dimensions than a group.