Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to force the Axis label to hide the negative sign (for negative values)?

I have a chart that has to do with ranking and want the lower values (higher rank) to display at the top rather than at the bottom. So the work around was to multiply everything by -1 and make them appear as positive values on the data points using Number formatting

#,##0 to #,##0;#,##0. The problem is that the formatting only worked on the values on data points but I also want to show the axis and grid rather than hiding it, but the number formatting did not work on the axis.

Is there any way I can get rid of the negative sign on the Axis?

2 Replies
Not applicable
Author

ranking.PNG

Siva_Sankar
Master II
Master II

John,

use Fabs function instead of multiplying by -1.

fabs( -3.8 )Returns 3.8

-Siva