Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Flipping the y axis on line chart

Hello,

I have a chart like this:

MindaugasBacius_0-1607414989351.png

The business wishes to reverse the y axis.

I found some solutions in the Community:

1. Changed expression by adding (expression)*-1

2. Added in Number tab > Format Pattern -#.##0,0%;-#.##0,0%

Sadly the axis doesn't appear with a minus sign and shows like this:

MindaugasBacius_1-1607415198478.png

But while Exporting data to excel the data is with minuses.

Tried just to move the axis with Shift + Alt but this didn't help also.

 

What I am missing here?

 

Thank you!

Labels (2)
1 Reply
Marcos_Ferreira_dos_Santos

Hi MindaugasBacius,

It seems that your challenge is to present the workaround with *-1 and convince your users not to carry results to Excel...

Good luck!