Adding currency conversion rate field

[danielnevitt]

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

[sujeetsingh]

Hope this link will help you

HOW TO CHANGE EURO VALUE ?? | Qlik Community

[#3]

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