topic Show more than 2 dimensions in a bar chart in QlikView

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 00:08:35 GMT

I need to show 3 dimensions Year, Product and Call Type and one measure activity count in a bar chart. I need all the dimensions to be displayed as bars without stacked bar. As soon as I add third dimension it takes that as stacked bar within the existing bar. User do not want to show any stacked bar. They want to show multiple bars separately for each dimension. Any help is greatly appreciated.

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 00:31:52 GMT

Hi,

You can use trellis chart option to show the third dimension without stack bar. You can find this in chart properties -> Dimensions -> Trellis -> Enable trellis

Regards,

Kiran.

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 00:55:24 GMT

Jolly, Thanks for your response. Trellis is creating multiple charts for each dimension value. User wants to see all the dimensions in a single bar chart nested in each other on x-axis. Please let me know any other ideas.

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 01:22:01 GMT

I dont think it can be done in QV 10. I dont know if it can be done using the latest release.

Regards,

Kiran.

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 01:27:45 GMT

Kiran,

I thought the same that it can't be done. Before I tell my users, would like to check with experts on this community.

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 05:22:25 GMT

Hi rqlikview,

you can show three dimensions in a bar chart, but how qlikview interprets and shows it and wat u expect it to do are two quite different things.

Qlikview can only "show" 2 dimensions, by that I mean first dimension on X-axis and second on Y-Axis. if you add a third dimension, it makes a bar chart a 3-d object, which qlikview shows by stacking it on top of each other.

In any case if you want to use three dimensions, you won't get the desired result ... the chart just won't make sense.

I think you should convince your users otherwise.

Rgrds,

Abhinava

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 15:35:50 GMT

Abhinava,

Thanks for your response. I agree with you. Qlikview creates third dimension on x-axis as a stack chart. But excel accommodates these kinds of nesting. User is comparing excel functionality and challenging Qlikview. Checking if this is possible or do I have to go back and tell them not possible.

Show more than 2 dimensions in a bar chart

swuehl — Tue, 20 Sep 2011 19:24:47 GMT

I think your problem is similar to the issue we discussed here:

http://community.qlik.com/message/150787#150787

Maybe the approach using a new concatenated dimension to reduce three dimensions to two will also work for you?

Regards,

Stefan

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 19:40:00 GMT

Stefan,

Appreciate your idea. I did follow the same approach and showed it to business. They are no ok with that approach. They want to see them nested on x-axis which excel can do easily. It seems like it is a limitation in Qlikview.

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 20:02:54 GMT

Maybe this could provide some pointers http://community.qlik.com/message/151030#151030

Show more than 2 dimensions in a bar chart

Tue, 20 Sep 2011 20:10:50 GMT

For more info please find the below graph that I am exactly looking for.

Show more than 2 dimensions in a bar chart

Wed, 21 Sep 2011 08:49:16 GMT

Hi rqlikview,

The graph that you have shown does not contain three dimensions!! there are only two, period and {Fax, Escript, Ttl} dimension.

You should add separate expressions into your qlikview chart for product1, product2, and total.

I think you will be able to achieve the same graph in Qlikview. I am also working on it.

Rgrds,

Abhinava

Show more than 2 dimensions in a bar chart

Wed, 21 Sep 2011 13:14:09 GMT

Abhinava,

Thanks for your response.

The graph has 3 dimensions. On the x-axis first one is month, second order type (Fax, Escript) and products on the legend as bars (product1, product2). If we add third dimension products to qlikview it creates a stacked bar instead of individual bars. Users needs it to be individual bars without stacking.

Show more than 2 dimensions in a bar chart

Wed, 21 Sep 2011 13:18:37 GMT

HI,

could you attach your data fragment for me to experiment.

Rgrds,

Abhinava

Show more than 2 dimensions in a bar chart

Thu, 22 Sep 2011 20:59:22 GMT

I convinced business to change the representation. Good on this. Thanks for your response.