topic Re: Negative Amount in QlikView

Negative Amount

upaliwije — Sun, 13 Jul 2014 10:01:21 GMT

In my data table I find some negative amount which I want to convert to positive figures in the loading script

TB:

LOAD BAL_ACCT_CODE,

NOTE,

CLA_CODE,

GROUP_CODE,

YEAR,

MONTH,

if (AMOUNT<0,AMOUNT*-1)as AMOUNT,

BCOD

FROM

[..\QVD\FACT_Table\Trial_Balance.qvd]

(qvd);

My script is as above but line in red does not give desired result. Pls see where there is any error in myscript

Re: Negative Amount

ashfaq_haseeb — Sun, 13 Jul 2014 10:04:06 GMT

Hi,

try to use fabs().

Look at the attached application

Regards

ASHFAQ

Re: Negative Amount

its_anandrjs — Sun, 13 Jul 2014 10:18:44 GMT

Try like below load script but what about that values which are not - ive by your line only -ive values convert to positive

TB:

LOAD

BAL_ACCT_CODE,

NOTE,

CLA_CODE,

GROUP_CODE,

YEAR,

MONTH,

if (AMOUNT < 0, AMOUNT * -1, AMOUNT ) as AMOUNT,

BCOD

FROM

[..\QVD\FACT_Table\Trial_Balance.qvd]

(qvd);

Ex:-

LOAD Amt, if(Amt < 0,Amt * -1,Amt)as AMT;

LOAD * Inline

[

Amt

-2

566

-4

-5

];

Re: Negative Amount

upaliwije — Sun, 13 Jul 2014 10:28:50 GMT

Thanks both of You