Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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 II
Partner - Master II

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