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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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