SQL Load script - make currency negative based on flag

[#1]

Hi im wondering what the sql code would be if i wanted to make a field negative (-) based on a flag. Because by default all values in the database are positive (+).

The conditions are if DRCR_FLG = -1 then the OSBASE_AMT should be negative, if DRCR_FLG = 1 then the OSBASE_AMT should be positive.

Currently my load script looks like the following:

-----------

TRANSACTIONS:
Load
DRCR_FLG,
OSBASE_AMT,
SQL SELECT * FROM ALI.TRX;

----------------

Regards

Jason

[Or · Accepted solution]

Try:

TRANSACTIONS:
Load
DRCR_FLG * OSBASE_AMT as OSBASE_AMT
SQL SELECT * FROM ALI.TRX;

[rotero]

ihave the same concept of prob

instead of flag field

i use the code value of the field for determining

this is my prob

http://community.qlik.com/thread/34074