sql case statement during edit script loading

rotero — Wed, 24 Aug 2011 02:13:29 GMT

hi i have a SQL table as my souce data and i want to effect this change in data representation

date field are

TRCD - numeric date referrring to transaction code (1=invoice and 3 =returns)

AMT - amt (no negative value)

what i want to achieve is when trcd=3 amt will represent data in negative status so that when i sum(amt) it will give me net sale

ex.

trcd=1

amt= 1000

trcd=3

amt=(1000)

kaushiknsolanki — Wed, 24 Aug 2011 05:19:34 GMT

Hi,

Try this way.

Load

trcd,

if(trcd = 3, amt * -1,amt) as new_amt;

Sql Select trcd, amt

from xyz

Regards,

Kaushik Solanki

topic sql case statement during edit script loading in QlikView