Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Combination of grouped and stacked bar chart (small model attached)

Hi,

is it possible to mix a grouped with a stacked bar chart?

Currently I'm using a grouped bar chart with one dimension and five expressions. One expression shall be changed to consist of two parts. I think the screenshot and the example qvw show it quite good.

Thanks,

Jens

7 Replies
Partner
Partner

Re: Combination of grouped and stacked bar chart (small model attached)

Hi Jens

Can you please check the app attached. It is little bit tricky. I have placed a chart over the other chart in step 1. But may be it will serve your purpose, otherwise their is no way to get grouped and stacked chart together.

Rajat

Not applicable

Re: Combination of grouped and stacked bar chart (small model attached)

Hi Rajat,

thanks for providing this solution. Problem is, when I change the selected territory from 'b' to 'a', there is a gap between the two bar parts. Is there a way to solve this?

Thanks,

Jens

Not applicable

Re: Combination of grouped and stacked bar chart (small model attached)

Ah, and the mouseover for the bottom part won't work.

Partner
Partner

Re: Re: Combination of grouped and stacked bar chart (small model attached)

Hi Jens,

Check this one, it will solve the problem you are facing when selection is changed.

But that mouse-over problem can't be rectified, as it is underlying chart, you can't get the value on mouse-over.

Regards

Rajat

Not applicable

Re: Re: Re: Combination of grouped and stacked bar chart (small model attached)

Hi,

I have made it, it looks the way I want to :-).

I had some help and ideas from a parallel thread, this can help others, too, hopefully:

Create a stacked bar chart with 6 dimensions in two separate bars

mixed.jpg

Month was my only dimension, I then added a second one which I called BarType. The four single bars got a single entry in that field, the stacked bar a combined one and two expressions, for each part a separate one,

Only issues are now, that the order is not in the way I want it (Should be Offen, Verloren, Gewonnen, Soll and the stacked one), I have no solution yet, and the legend (Safe+Threat, TCV Open) that needs to be removed.

Partner
Partner

Re: Combination of grouped and stacked bar chart (small model attached)

Hi Jens,

Can you post your current qvw file.

Regards

Rajat

Not applicable

Re: Re: Combination of grouped and stacked bar chart (small model attached)

Hi,

I can again only post my model. Hope it helps

Regards

Jens