Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
choy
Contributor II
Contributor II

Change negative values to positive value in chart value label

Hi All,

I've create a butterfly chart with % value label, but for Female we should change it to positive values not negative %.

Any ideas, how can I change it?

choy_0-1689646575581.png

 

Labels (2)
2 Replies
BrunPierre
Partner - Master
Partner - Master

Hi, You could use the "Fabs" function.

=Aggregation function(Fabs(Measure))

MarcoWedel

maybe using a number format that formats negative values without minus sign:

MarcoWedel_0-1689707047357.png

MarcoWedel_1-1689707088197.png