Discussion Board for collaboration related to QlikView App Development.
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:
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.
Hope this link will help you
HOW TO CHANGE EURO VALUE ?? | Qlik Community
is your date used as a dimension in your graph ?
if so sum(values * exchangert) should work
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))