topic SQL Load script - make currency negative based on flag in QlikView

SQL Load script - make currency negative based on flag

Thu, 08 Jul 2010 13:39:38 GMT

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

SQL Load script - make currency negative based on flag

Or — Thu, 08 Jul 2010 14:00:12 GMT

Try:

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

SQL Load script - make currency negative based on flag

rotero — Wed, 24 Aug 2011 02:26:27 GMT

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