9 Replies Latest reply: Nov 12, 2009 12:17 PM by umangu2000

# Invert Axis in a Line Chart

Hi,

It may sound quite easy but I'm new with qlikview. [:\$]

I want to showcase the time series of ranks in a line chart However to show the same I need to invert the axis else the ranks would appear incorrectly

• ###### Invert Axis in a Line Chart

Select in chart options, the Sort sheet

Then select Sort by Y Value and select Ascending or Descending value.

Rgds,

Sébastien

• ###### Invert Axis in a Line Chart

In this case the order of years would change - it would not come chronologically . . .

• ###### Invert Axis in a Line Chart

• ###### Invert Axis in a Line Chart
 Year Rank 2005 5 2006 9 2007 2 2008 6 2009 1

The above is the yearly rank of a person, and i want to show the same in a qlikview chart

A normal line chart would show the trend line going upwards from 2005-06 while the rank has actually decreased from 5th -9th

Need a manner to show the same wherein the line falls from 2005-06 as the rank is falling

thanks,

Umang

• ###### Invert Axis in a Line Chart

Maybe you could create an expression to calculate the difference between Rank N and Rank N-1, then you base your chart on this expression ?

• ###### Invert Axis in a Line Chart

if i understood you correctly , then multiplying the rank by (-1) will do the trick.

the expression should be Rank*(-1)

Regards,

Tariq

• ###### Invert Axis in a Line Chart

Yep , this is something you can think about...

• ###### Invert Axis in a Line Chart

That is Gr8 The only problem now would be that the texts or numbers which ever i show would be negative

Need to figure out something to correct that as well

Thanks Guys appreciate it

• ###### Invert Axis in a Line Chart

Got it the final solution would be as Ansari suggested And for the negative numbers you could format the numbers into money format so that there are no negative signs

Thanks to Spastor & Ansari - could get to what i wanted to do