topic Reverse axis on a scatter chart in QlikView

Reverse axis on a scatter chart

Mon, 24 Jan 2011 12:48:01 GMT

Hello all,

I'd like to have a "normal" scatter chart, but with two little diferences.

1. The x axis should be on top

2. The scale should be on reverse, ie, from 100% to 0%

The Y axis is the normal one.

Does anyone knows how to do it?

Thanks in advance.

João

Reverse axis on a scatter chart

Mon, 24 Jan 2011 14:01:42 GMT

Hi João, if I remember correctly, you could check Static Min and Static Max boxes on the Axes tab in object properties in the Scale section for X axis and enter 100 for Static Min and 0 for Static Max. Another approach would be to reverse it in expression for example:

=if([X_COORDINATE]>0,Sum (100-[X_COORDINATE]),"")

Let me know whether it worked.

Reverse axis on a scatter chart

Mon, 24 Jan 2011 15:30:51 GMT

Sorry Mark, but it doesn't work.

this is what happens

With your sugestion, the x-axis scale became: 0,0 0,1 0,2 0,3 ... 1,0

What I want is: 100 67 33 0

And if it's possible to be on top of the chart was excellent.

The other solution you gave for the expression don't have no impact on the x scale

Reverse axis on a scatter chart

raajeshn — Tue, 10 Apr 2012 09:20:00 GMT

Hi Jpereir,

Any luck on this? I am also struck up in a similar problem. Appreciate your help.

Thanks & Regards,

Raajesh N