Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change all negative values to positive

Hi

I would like to change one or more negative values to positive, and display them in a pie chart and a table.

The negative values are among positive. I am using the values to sum and display them.

How do I change all negative values in a pie chart to a postive one?

Thanks!

1 Solution

Accepted Solutions
Not applicable
Author

You can use Fab() function to convert the negative and positive values to positive values.

- Sridhar

View solution in original post

2 Replies
Not applicable
Author

You can use Fab() function to convert the negative and positive values to positive values.

- Sridhar

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Use fabs() function.

    This will convert your negative values into positive.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!