Load certain values as negatives

gerhardl — Fri, 15 Apr 2011 12:52:24 GMT

Hi,

How would I go about loading the values of certain fields as negative, IF another field meets certain criteria?

I have the following 2 fields - [Transaction Amount] and [Transaction Code].

Certain transactions are purchase reversals, so if I load them as negative numbers it is easier for me to show the Turnover (I can just sum the totals).

My statment must be:

Load [Tran Amount] as negative value IF [Tran Code] = 36 or 931.

Thanks,

Load certain values as negatives

deepakk — Fri, 15 Apr 2011 12:56:22 GMT

hi,

If (code = 454 or code =400 , Amount*-1, Amount) as Amount.

I hope this helps.

topic Load certain values as negatives in QlikView

Load certain values as negatives

Load certain values as negatives