currency exchange rate

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have an excel data from 2015 until now (daily exchange rates) where you have from currency and to currency. To currency is always USD. I have another set of data that I am converting into USD. The problems comes when the transaction currency is USD and it is of course missing from my daily exchange rates as it would be 1. How can I add this to my data. I tried following after joining the two datasets together:

num(If(transaction_currency = 'USD', conversion_rate = '1', conversion_rate),'#,####') as new_conversion_rate

But still says for the USD transaction that the conversion rate is 0.

Anyone?

Thanks

Johanna

Re: currency exchange rate

marcus_sommer — Wed, 20 Jun 2018 12:38:34 GMT

You could try it in this way:

num(alt(conversion_rate, 1),'#,####') as new_conversion_rate

- Marcus

topic currency exchange rate in QlikView

currency exchange rate

Re: currency exchange rate