topic Re: Adding currency conversion rate field in QlikView

Adding currency conversion rate field

danielnevitt — Wed, 12 Feb 2014 12:15:47 GMT

Hi,

I have an expression that calculates a value in USD and I would like to convert this to EUR based on the current day exchange rate (this data is held within our system).

The fields are:

curr_cd

exchange_date

exchange_rt

I thought I could add the following expression field to my Table, however this does not work:

IF(exchange_date='12/02/2014' AND curr_cd='EUR',exchange_rt)

Basically I want to either add a column showing today's EUR exchange rate.

Any help would be much appreciated.

Regards,

Daniel

Re: Adding currency conversion rate field

sujeetsingh — Wed, 12 Feb 2014 12:21:02 GMT

Hope this link will help you

HOW TO CHANGE EURO VALUE ?? | Qlik Community

Re: Adding currency conversion rate field

Wed, 12 Feb 2014 12:43:01 GMT

Hi Daniel

is your date used as a dimension in your graph ?

if so sum(values * exchangert) should work

if not

sum(values) * avg(exchange_rt) would take the average of exchange_rt for all selected date

if you want to apply only last exchange_rt to all values

sum(values) * aggr(exchanger_rt, max(date))

best regards

Chris