Absolute Sum while loading the script

[#1]

Hi, I would like to know if there is any function that let sum the absolute values while the script is loading. Something like this:

MapValuedQuantity:
MAPPING LOAD
 [Document No_], [Valued Quantity];
SQL SELECT     [Document No_], Sum(ABSOLUTE([Valued Quantity])) AS [Valued Quantity]
FROM         "$(_DBName)"."$(_DBOwner)"."$(_CompanyName)$Value Entry" 
GROUP BY [Document No_];

I've tried the fabs() but it doesn't work here.

Good weekend to you all.

[vijay_iitkgp]

Hi You can use workaround as

Sum(If(Quantity<0,Quanitity*-1,Quantity)) as AbsQuantity

[CELAMBARASAN]

Hi,

     In qlikView use Sum(Fabs([ValueQuantity]))

Celambarasan

[jagan]

Hi,

Try like this

TableName:

LOAD

    F1,

    Fabs(F2) AS F2;

LOAD * INLINE [

    F1, F2

    a, -1

    b, 2

    c , -3

];

Regards,

Jagan.

[jagan · Accepted solution]

Hi,

Try this script

Temp:
[Document No_],
[Valued Quantity],

1 AS Temp;

SQL SELECT     [Document No_], [Valued Quantity] AS [Valued Quantity]
FROM         "$(_DBName)"."$(_DBOwner)"."$(_CompanyName)$Value Entry";

MAPPING LOAD

LOAD
[Document No_],

Sum(fabs([Valued Quantity])) AS [Valued Quantity]

RESIDENT Temp

GROUP BY [Document No_];

DROP TABLE Temp;

Regards,

jagan.

[#6]

Hi thanks you three for your time. I've tried the three methods and the jagan's one was the only that worked.

Nice day.