topic Reverse Expresion in X-Y Chart in QlikView

Reverse Expresion in X-Y Chart

Anonymous — Wed, 26 Jan 2011 18:28:49 GMT

Is there a way to reverse value on the X- axes in a charts?

I am using a Rank in the Expression and when I use this in a Chart is returns:

rank

A B C D

Ofcourse I want it the other way around so number 1 is on top

rank
1

A B C D

I can not find this, but it I am sure this is possible, somehow ....

Reverse Expresion in X-Y Chart

Anonymous — Wed, 26 Jan 2011 18:32:46 GMT

Here is how it looks:

Reverse Expresion in X-Y Chart

matt_crowther — Wed, 26 Jan 2011 19:18:31 GMT

Bit of a work around but this is a possible:

In the espression eg: =rank use: '=rank*-1' to invert the numbers - this will make the axis show in descending order.

Unfortunately I can't find a neater solution.

For even more work-around-ness add a white text object over all the minus signs so they appear as positives!? alternatively hide the axis all together and replace with your own in a text object which will be fine as long as the Y-axis never changes...which isn't likely!

Guess it could work.

Hope that helps,

Matt - Visual Analytics Ltd

Reverse Expresion in X-Y Chart

Anonymous — Wed, 26 Jan 2011 19:31:19 GMT

Yes that is an option which I could use, and in this case I could use it (because the amount stays the same) But ther must be a better way right?

Any suggestions?

Reverse Expresion in X-Y Chart

Anonymous — Mon, 23 May 2011 06:48:38 GMT

Nobody found a solution for this yet?

Is there a way to ask QlikTech if this is even possible at all?

Re: Reverse Expresion in X-Y Chart

Mon, 23 May 2011 06:56:31 GMT

Hi,

In Properties - Presentation, there is tab called "Reverse" on right top side.

Please find attachment.

You can use it.

I think simplest way.

Reverse Expresion in X-Y Chart

Anonymous — Mon, 23 May 2011 07:02:55 GMT

Thanks for the reply but that is not what this option is for:

When this option is checked, the values shown in the chart will be reversed, i.e. if the 10 highest values are shown and the box is checked the chart will then show the 10 lowest values.

Re: Reverse Expresion in X-Y Chart

prieper — Mon, 23 May 2011 14:44:12 GMT

You may sort by the ASCII-value of the items, see the attached one

HTH

Peter

Re: Reverse Expresion in X-Y Chart

Anonymous — Mon, 23 May 2011 17:15:51 GMT

Thanks, but I don't see how that is going to help me.

To clearify take a look at this picture:

What I want is to reverse the ranking, so number 1 will be on top.

Re: Reverse Expresion in X-Y Chart

prieper — Mon, 23 May 2011 20:12:01 GMT

Agree - had misunderstood your question

What about a combination of negative Ranking, no 0-values and re-formatting of the Y-values?

See the attached example

HTH
Peter

Re: Reverse Expresion in X-Y Chart

Anonymous — Tue, 24 May 2011 06:20:39 GMT

Thanks, it is the same workaround matt.crowther offert earlier.

I was using this, but I didn't like the minus-sign in the chart and on the data.

Changing the format as you did is as simple as it is briljant 🙂

Thanks again!

Reverse Expresion in X-Y Chart

Dayna — Thu, 22 Dec 2011 16:55:54 GMT

Peter,

I'm struggling to replicate your chart - how did you change the axis??

Kind Regards,

Dayna