Trying to avoid stacked bars within a bar char with 3 dimensions

[lfalmoguera]

Firs of all thank so much for the help I am finding in this communitty! It´s brilliant!

I am "fighting" with a Bar Char with 3 dimensions in order to avoid that QV converts it into a stacked bar char.

I have this column (just a quick sample).

Country	Product	Apr-10	May-10	Jun-10
ES	A	0.89	0.80	0.29
ES	B	0.55	0.29	0.65
ES	C	0.70	0.82	0.87
FR	A	0.90	0.69	0.69
FR	B	0.64	0.21	0.77
FR	C	0.48	0.52	0.86
UK	A	0.29	0.64	0.94
UK	B	0.28	0.62	0.79
UK	C	0.61	0.39	0.85

I want to avoid that it becomes an stacked bar char.

I have tried to use different dimensions baded in the product (if(Product='A',Data) etc.. But it just looks the way I want if I select just one month.

Is there any way to achieve this? O have I found something that cannot be produced within QV?

Find attached the QV and the desired bar (in jpeg)

Thanks a lot in advance.

Regards.

[lfalmoguera]

[boorgura]

That is Qlikview's behavior.

you can only achieve something similar to what you want by using Trellis.

[lfalmoguera]

What´s Trellis Rocky?

[boorgura]

Trellis is to show a chart as a set of charts.

Attached is your chart with Trellis enabled.

[#6]

Hi Ifalmoguera,

Get chart properties and go to dimension tab, you can see on the left bottom Trellis.... Click on trellis button , it will open up another window with trellis settings , you need to tick on enable trellis chart checkbox and click ok. Try enabling secondary trellis chart, so you can know the difference by looking at.

[lfalmoguera]

Thank you so much guys!

It does not work exactly as I was looking for but I guess it will be fine.

Excellent!