Convert negative values to postive

[#1]

Hi

How can i convert a measure which is displaying as all negatives to positive vales?

Thanks

[maxgro]

example

from qlik online help

fabs(x)

The absolute value of x. The result is a positive number.

Examples:

fabs( 2.4 ) returns 2.4

fabs( -3.8 ) returns 3.8

[Anonymous]

can you share some dummy data?

[senarath]

Hi,

IF you use *-1, your positive amounts may convert into negatives. So if your data is not 100% negatives, pls use fabs()

thanx

[hannan_t]

Try using the FABS function. It will surely resolve the issue.

e.g

fabs(Amount)

[#6]

should i use the fab function in the script or in the expression?

[ashfaq_haseeb]

Hi,

have a look at my reply.

Regards

ASHFAQ

[maxgro]

you can use fabs

- in script

- in chart

[#9]

thanks.  So could i say for example use the following:

Fab (Income) as Income

[ashfaq_haseeb]

Hi,

Sure you can use that

Regards

ASHFAQ

[PrashantSangle]

Hi,

Its FABS(FieldName) as New_fieldName

Regards