Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kolakiran
New Contributor II

How to convert the amount based on selected currency symbol

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

1 Reply
Not applicable

Re: How to convert the amount based on selected currency symbol

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

Community Browser