topic Re: plotting a 'grouped' bar chart for more than 1 dimension in QlikView

plotting a 'grouped' bar chart for more than 1 dimension

Fri, 31 Aug 2012 05:58:19 GMT

Hi,

I need to compare 2 companies based on different parameters on a yearly data.

As shown below, using a combo chart with 1 dimension (year) , 2 expressions (company 1 and company2) and setting the style as 'Grouped' subtype, I am able to plot the foll. chart:

But as shown as I add another dimension (like size, coupon etc), the grouped style is removed and is replaced by Stacked.

Is there a workaround for this issue?

Re: plotting a 'grouped' bar chart for more than 1 dimension

Anonymous — Fri, 31 Aug 2012 06:41:29 GMT

Hi,

How do you want this to be represented ? That the two bars for the two companies remain, split by year. How do you want the size or coupon dimensions to be represented ?

You could try adding them as the first dimension and then setting your chart up as a Trellis. This would enable you to show for example 9 bar charts in the same objects (3 columns by three rows), with each chart being the same as your top chart but for a specific size or coupon.

Regards,

Jonathan

Re: plotting a 'grouped' bar chart for more than 1 dimension

Fri, 31 Aug 2012 06:53:12 GMT

probably changing bar chart to line chart:(

Re: plotting a 'grouped' bar chart for more than 1 dimension

Tue, 11 Sep 2012 02:16:50 GMT

Hi,

Is it possible without using trellis chart? Like expressions should be represented in Bar only (Not stacked).

Regards,

Yojas