topic Re: Stacked bar chart without multiple expressions for categories in QlikView

Stacked bar chart without multiple expressions for categories

Wed, 28 Nov 2012 17:07:00 GMT

Hello

I have had a look through the mutitude of bar graph questions but couldn't find a solution to this. Apologies if I have missed it.

I am trying to create a stacked bar chart showing a total of letters sent by letter type with a line for cumulative total cost (these are my 2 expressions). The dimension is date.

Creating a non stacked version with just total letters sent as a bar and total cumulative cost as a line works fine - however I am unsure how to stack the bar chart to show a breakdown of letter type without creating an expression for each letter type. This isn't practical as I believe it means each time a new letter is added I will have to maually update.

Is there a way I can add letter type to the dimensions to have a stacked bar showing total letters sent and the contribution of each letter type to this total as well as having my cumulative cost line?

Thanks in advance.

Re: Stacked bar chart without multiple expressions for categories

Gysbert_Wassenaar — Wed, 28 Nov 2012 19:05:44 GMT

Nope, sorry. The combo chart can't do stacked bars with two dimensions. I think the only way is to overlay two charts by making background, legends and axes etc transparent after lining the charts up as best as possible. See attached example.

Re: Stacked bar chart without multiple expressions for categories

Thu, 29 Nov 2012 09:09:02 GMT

Ok, thanks for the response.

At least now I can give up trying to work it out - I'll give the transparent chart a go.

Re: Stacked bar chart without multiple expressions for categories

mikecrengland — Thu, 29 Nov 2012 16:23:58 GMT

Unless I misunderstood the problem, you can do a stackedbar/line combo chart. Use a single dimension, and in my case, 5 expressions.

Re: Stacked bar chart without multiple expressions for categories

Thu, 29 Nov 2012 16:30:08 GMT

Thanks, however although this does work it would mean whenever a new letter was released I would have to manually add an expression which wouldn't be practical.