topic Re: Bar chart - how to create several groups of stacked columns? in QlikView

Bar chart - how to create several groups of stacked columns?

datanibbler — Tue, 08 Oct 2013 07:48:10 GMT

Hi,

I'm just experimenting again with a pure bar chart where I have the option of stacking columns.

=> I have three sets of two figures each with one figure being smaller than the other, like that:

- Booked: 5

- Taken: 3

=> Thus, I'd like to stack the "Taken" onto the "Booked" - but every set individually.

Can I do that in any way?

Thanks a lot!

Best regards,

DataNibbler

Re: Bar chart - how to create several groups of stacked columns?

Gysbert_Wassenaar — Tue, 08 Oct 2013 08:16:00 GMT

If you want groups of stacked bars you'll need three dimensions with one expression in your chart or two dimensions with more than one expression.

Re: Bar chart - how to create several groups of stacked columns?

MK_QSL — Tue, 08 Oct 2013 08:26:30 GMT

Please check the attachment.

Re: Bar chart - how to create several groups of stacked columns?

datanibbler — Tue, 08 Oct 2013 08:27:23 GMT

Hi Gysbert,

I guess that means I cannot do it that way. My dimension is "day" - that is the connection between every table and the master_calendar. I cannot make several separate dimensions - I'd have to generate two more master_calendars which would make the data_model overly complicated and redundant.

Then I'll just have to make do with a multi_diagram again.

Thanks a lot anyway!

Best regards,

DataNibbler

Re: Bar chart - how to create several groups of stacked columns?

datanibbler — Tue, 08 Oct 2013 08:30:23 GMT

Hi Manish,

thanks for the help!

However, that is what I can currently do - in your chart, too, there is only one group of stacked expressions per dimension_point. I would need a way to display three such groups simultaneously.

Thanks anyway!

Best regards,

DataNibbler

Re: Bar chart - how to create several groups of stacked columns?

MK_QSL — Tue, 08 Oct 2013 08:32:18 GMT

Is this you are looking for?

Re: Bar chart - how to create several groups of stacked columns?

datanibbler — Tue, 08 Oct 2013 08:42:00 GMT

Hi Manish,

no. I only want to stack to columns on one another - but I want three groups_of_two on every dimension_point - side by side.

Never mind. We'll have to live with the fact that some things just cannot be done.