topic Change all negative values to positive in QlikView

Change all negative values to positive

Fri, 24 Jun 2011 11:15:36 GMT

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!

Fri, 24 Jun 2011 11:34:23 GMT

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

- Sridhar

kaushiknsolanki — Fri, 24 Jun 2011 11:35:13 GMT

Hi,

Use fabs() function.

This will convert your negative values into positive.

Regards,

Kaushik Solanki