topic Re: Reversing axes on scatter chart in QlikView

Reversing axes on scatter chart

Wed, 17 Dec 2014 09:32:33 GMT

Hello,

I am trying to reverse my X and Y axes on my scatter chart. (i.e. 0 - 100% should display as 100 - 0%). I would normally adjust sort order in a chart, but as in a scatter chart my dimensions are essentially expressions, and vice versa, I am at a loss as to how to do this.

In addition to reversing the order of both Cumulative Volume and CoV, I would like my X axis to be on the top of the graph and my Y axis to be on the right of the graph.

Thanks for your help!

Re: Reversing axes on scatter chart

Michiel_QV_Fan — Wed, 17 Dec 2014 09:37:57 GMT

You could create negative values and format these to be shown without a '-' sign of () for minus.

Re: Reversing axes on scatter chart

Thu, 18 Dec 2014 17:38:55 GMT

Excellent, thank you!

Re: Reversing axes on scatter chart

Thu, 18 Dec 2014 17:52:40 GMT

Actually, Michiel, could you elaborate a little bit further please?

I was able to reverse my axes by adding a '-' in front of my expression, however I'm not sure how to achieve this without using the '-' sign, or how to hide it?

Thanks very much!

Re: Reversing axes on scatter chart

Michiel_QV_Fan — Fri, 19 Dec 2014 10:43:25 GMT

multiply your expression with -1 to create the negative values.

Go to number format and create a negative format just like the positive format:

fixed to: #,##0;#,##0

Re: Reversing axes on scatter chart

Anonymous — Fri, 05 Feb 2016 07:46:22 GMT

Hi Michiel,

I have multiplied the expression with -1 and now when I go to Number tab and select Fixed to for y expression and change the format from #,##0 to #,##0;#,##0 , there is no change.

Can you please help me with this.

Thanks,

Niharika

Re: Reversing axes on scatter chart

Michiel_QV_Fan — Mon, 08 Feb 2016 13:24:45 GMT

Can you post some printscreens?

Re: Reversing axes on scatter chart

Mon, 08 Feb 2016 19:27:33 GMT

Hi Niharika,

Make sure you check the following option on the chart properties.

Ex: If you would like to reverse Y axis, then Check Static Max option and set to 0 for that particular axis.

Re: Reversing axes on scatter chart

Anonymous — Tue, 08 Mar 2016 14:11:38 GMT

Thanks Swetha,

That's really helpfull.