Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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.