How to convert the amount based on selected currency symbol

[Anonymous]

Hi Experts,

How to convert the amount based on selected currency symbol  in report

EX:

The amount is 1000 INR ,

1. If I select $ symbol in filter it has to show 1000 / current Dollar Exchange rate = Amount in Dollars
2. If I select Pound symbol in filter it has to show 1000 / current Pound Exchange rate = Amount in Pounds

Thanks in Advance

Regards

Kiran

[#2]

Hi Kiran,

Check the approach given here.

https://community.qlikview.com/thread/193966

Create another table for currency conversion and instead of Target_Currency, use your Symbol as a column.

Although it is in QlikView, you  can use the same approach in QlikSense.

Regards,

Rohan