Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert currency?

how should i show Revenue in rupees into Dollar?

4 Replies
puttemans
Specialist
Specialist

multipy or divide the revenue in rupees by the current exchange rate...

gautik92
Specialist III
Specialist III

if it is in indian rupees in  database try to divide it by 65 in the script and use it in the expressions

nigel987
Creator II
Creator II

As far as I know, it's kind of best practice to define the conversion rate between the two currencies as a variable. The variable name should start with v, so for example: vRupeeToUSDollar = 0,01

The variable can then be used in your expression.

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Your solution here depends on how accurate you need your conversion to be.

For a simple conversion, apply a single rate based on a hard coded conversion rate or a variable.

For a more accurate conversion, load a table of exchange rates from a site such as xe.com - Autoextraction Prohibited -

Then match the date to the date your transaction relates to and apply the conversion.