Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Change all negative values to positive

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

- Sridhar

2 Replies
Not applicable

Re: Change all negative values to positive

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

- Sridhar

Change all negative values to positive

Hi,

    Use fabs() function.

    This will convert your negative values into positive.

Regards,

Kaushik Solanki