Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Adding currency conversion rate field

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

2 Replies
sujeetsingh
Master III
Master III

Hope this link will help you

HOW TO CHANGE EURO VALUE ?? | Qlik Community

Not applicable

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