topic Re: Negative numbers to positive in QlikView

Negative numbers to positive

sculptorlv — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I guess the quastion is very simple, I am just looking for corresponding function.

I have one columns with such results:

Value

-4

-5

-6

How can I make a SUM of all number with excaption, that all numbers are positive?

1 + 2 +4 + 5 +6 + 6

Something like SUM (MODULE(Value)) - where Module is unknown function to me...

Thank you in advance.

Re: Negative numbers to positive

swuehl — Tue, 29 Mar 2016 11:09:01 GMT

Try

=Sum(Fabs(Value))

Re: Negative numbers to positive

maxgro — Tue, 29 Mar 2016 11:09:52 GMT

maybe fabs, this is a copy from the qlik 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: Negative numbers to positive

Chanty4u — Tue, 29 Mar 2016 11:11:39 GMT

sum(fabs(value))

fabs(sum(value))

Re: Negative numbers to positive

avinashelite — Tue, 29 Mar 2016 11:12:27 GMT

use the fabs() function

fabs(your_expression)

Re: Negative numbers to positive

sculptorlv — Tue, 29 Mar 2016 11:16:46 GMT

Thanks to all of you!

Re: Negative numbers to positive

Kushal_Chawda — Tue, 29 Mar 2016 11:17:21 GMT

Go with fabs function

=sum(fabs(Value))

sum(if(Value< 0, Value*-1,Value))

Re: Negative numbers to positive

engishfaque — Tue, 29 Mar 2016 11:25:04 GMT

Dear Ruslans,

Here is a small description from QlikView Help regarding fabs function.

fabs(x): The result is a positive number.

Examples:

fabs( 2.4 ) returns 2.4

fabs( -3.8 ) returns 3.8

Use listed below expression for your scenario.

=Sum(fabs(Value))

Kind regards,

Ishfaque Ahmed