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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
Creator III

Create Negative number into positive

Hi guys,

Can anyone give me the number format to convert negative number to positive?

This is what I am looking for:

14.2% as 14.2%

-11.3% as 11.3%

Thanks in advance!

Regards,

Varun

1 Solution

Accepted Solutions
sunny_talwar

Sure May be like this:

Fabs(YourExpression)

View solution in original post

5 Replies
sunny_talwar

Have you look at the fabs() function? -> QlikView ‒ Fabs - script and chart function

varunreddy
Creator III
Creator III
Author

Should I use it in expression?

sunny_talwar

Sure May be like this:

Fabs(YourExpression)

varunreddy
Creator III
Creator III
Author

Thank You Sunny. Got to know some new function.

Regards,

Varun

sunny_talwar

No problem