Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
New Contributor III

Currency Conversion

Hi All,

I have a quick question. I am trying to convert foreign currency to USD. I have a conversion table with four fields

  • Fiscal year (Current)
  • from currency
  • multiply rate

I need to able to identify which is foreign currency and convert it into Local currency. I have a field in my other table which indicates which currency it is.

How do I do this??