topic Re: Graph Question in QlikView

Graph Question

Thu, 21 Jul 2011 13:06:10 GMT

I have a pivot table whereby there is one dimension and four expressions. When I create a chart from the pivot table the dimension gets placed on the X axis and the the expressions are in the legend. It looks like this:

What I would like it to look like is this:

Is there a way to flip the axis?

Graph Question

Thu, 21 Jul 2011 14:23:53 GMT

There are no images ?? or might be they are uploaded in the wrong format. Can you please show a sample app or any other images? Normally under the Properties-> Axes you will have the setting for expressions etc. But this is again available only for some chart types.

Re: Graph Question

Thu, 21 Jul 2011 14:42:02 GMT

Mady,

Thank you for the response..

This is how Qlikview displaysmy data…as you can see from my excel graph (fig 2) I need the data reversed.

Graph Question

Thu, 21 Jul 2011 15:16:20 GMT

I think its showing in Stacked View, You may try this,

Goto Properties-> Style -> select Grouped...hopefully that solves your problem

Re: Graph Question

Thu, 21 Jul 2011 15:22:28 GMT

Mady,

That wont do it....if you can see I want the data in the legent to be the axis and the axis to be the legend....do you know if this is possile? I need the data transposed

Re: Graph Question

Thu, 21 Jul 2011 15:26:00 GMT

I need the Qlikview graph to look like the excel graph....Qlikview is the first graph. Notice the difference of the X axis