How to use currency exchange rates in Qlik Sense

[mikel_de]

Hello everybody!

I have a report that needs to be updated on a monthly basis. The problem is that there are different currencies and I have to convert all values to EUR using a monthly exchange rate.

I attached a sample of the data and the exchange rates list. What I need is a way to divide the values in the column Price by the respective values in the column Currency_Rate  and have the result in a new column named Price_EUR. Of course the formula needs to pick up the right currency and the right monthly exchange rate.

I have no idea how to do this and would appreciate any help! Thank you!

- Mikel

[steve_br]

Hi Rahul!

This is awesome, thank you so much for this solution! It works perfectly!

Best,

Steve

[rahulpawarb]

Cheers,

Rahul

[dineshraj]

Hi Mike,

Please find the below attachment.

Thanks

Dineshraj