topic Re: Convert negative values to postive in QlikView

Convert negative values to postive

Mon, 11 Aug 2014 10:27:38 GMT

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

Thanks

Re: Convert negative values to postive

Anonymous — Mon, 11 Aug 2014 10:29:11 GMT

Try to load

-field

Re: Convert negative values to postive

maxgro — Mon, 11 Aug 2014 10:30:34 GMT

fabs for absolute value

Re: Convert negative values to postive

PrashantSangle — Mon, 11 Aug 2014 10:30:45 GMT

Hi,

In front end you can use

fabs()

multiply with field into -1

Regards

Re: Convert negative values to postive

ashfaq_haseeb — Mon, 11 Aug 2014 10:31:19 GMT

Hi,

look at Fabs() function

Regards

ASHFAQ

Re: Convert negative values to postive

Mon, 11 Aug 2014 10:31:25 GMT

do you have an example

Re: Convert negative values to postive

Mon, 11 Aug 2014 10:31:45 GMT

sorry do you have an example

Re: Convert negative values to postive

amit_saini — Mon, 11 Aug 2014 10:34:10 GMT

Hi,

Try this:

You could change it in Number formatting tab.For both positive and negative as same

#,###;#,###

Second try this also:

use fabs() function hope this could help u

from QV 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

Thanks,

Re: Convert negative values to postive

PradeepReddy — Mon, 11 Aug 2014 10:34:31 GMT

Try with FABS()...

Ex:

FABS(2.4 ) returns 2.4

FABS(-3.8 ) returns 3.8

Re: Convert negative values to postive

ashfaq_haseeb — Mon, 11 Aug 2014 10:34:46 GMT

Hi,

Run this script and drop value1 and value2

Load *,fabs(Value1) as Value2;

load * Inline

[

Date,Value1

01-01-2014,-1,

02-01-2014,-2,

03-01-2014,-1

04-01-2014,-4,

05-01-2014,-1,

06-01-2014,-6,

07-01-2014,-2,

08-01-2014,-8

09-01-2014,-5,

10-01-2014,6,

]

Regards

ASHFAQ

Re: Convert negative values to postive

maxgro — Mon, 11 Aug 2014 10:35:40 GMT

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

Re: Convert negative values to postive

Anonymous — Mon, 11 Aug 2014 10:37:38 GMT

can you share some dummy data?

Re: Convert negative values to postive

senarath — Mon, 11 Aug 2014 10:43:15 GMT

Hi,

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

thanx

Re: Convert negative values to postive

hannan_t — Mon, 11 Aug 2014 10:52:00 GMT

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

e.g

fabs(Amount)

Re: Convert negative values to postive

Mon, 11 Aug 2014 11:07:24 GMT

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

Re: Convert negative values to postive

ashfaq_haseeb — Mon, 11 Aug 2014 11:13:20 GMT

Hi,

have a look at my reply.

Regards

ASHFAQ

Re: Convert negative values to postive

maxgro — Mon, 11 Aug 2014 11:30:03 GMT

you can use fabs

- in script

- in chart

Re: Convert negative values to postive

Mon, 11 Aug 2014 12:16:58 GMT

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

Fab (Income) as Income

Re: Convert negative values to postive

ashfaq_haseeb — Mon, 11 Aug 2014 12:18:17 GMT

Hi,

Sure you can use that

Regards

ASHFAQ

Re: Convert negative values to postive

PrashantSangle — Mon, 11 Aug 2014 12:18:26 GMT

Hi,

Its FABS(FieldName) as New_fieldName

Regards