topic Re: Loading amount values in QlikView

Loading amount values

danielnevitt — Fri, 18 Oct 2013 14:06:58 GMT

Hi,

I'm trying to show Buy trades as a negative amount and Sell trades as a positive amount.

Presently our data shows an absolute value (EXTENDED_AMT).

Ideally I would like to create a new column in the load statement.

Any help with this will be much appreciated.

Regards,

Daniel

Anonymous — Fri, 18 Oct 2013 14:20:50 GMT

Hi,

Can you attach a sample data model so we can have a better understanding of your problem?

marcus_sommer — Fri, 18 Oct 2013 14:20:59 GMT

Perhaps so: if(categorie = 'buy', value * -1, value)

- Marcus

Gysbert_Wassenaar — Fri, 18 Oct 2013 14:28:37 GMT

Perhaps something like this:

TableX:

LOAD

FieldX,

FieldY,

TradeType,

EXTENDED_AMT

if(TradeType='Sell', EXTENDED_AMT, -EXTENDED_AMT) as AMOUNT,

...other fields....

FROM ...somewhere...;

danielnevitt — Fri, 18 Oct 2013 14:47:21 GMT

Thank you for the replies.

I used the If statement provided by Marcus in the end and it works perfectly.

Regards,

Daniel