topic How to convert currency? in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960485#M978513 <HTML><HEAD></HEAD><BODY><P>how should i show Revenue in rupees into Dollar?</P></BODY></HTML> Thu, 20 Aug 2015 05:55:55 GMT 2015-08-20T05:55:55Z How to convert currency? https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960485#M978513 <HTML><HEAD></HEAD><BODY><P>how should i show Revenue in rupees into Dollar?</P></BODY></HTML> Thu, 20 Aug 2015 05:55:55 GMT https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960485#M978513 2015-08-20T05:55:55Z Re: How to convert currency? https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960486#M978514 <HTML><HEAD></HEAD><BODY><P>multipy or divide the revenue in rupees by the current exchange rate...</P></BODY></HTML> Thu, 20 Aug 2015 09:55:36 GMT https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960486#M978514 puttemans 2015-08-20T09:55:36Z Re: How to convert currency? https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960487#M978515 <HTML><HEAD></HEAD><BODY><P>if it is in indian rupees in&nbsp; database try to divide it by 65 in the script and use it in the expressions</P></BODY></HTML> Thu, 20 Aug 2015 09:56:47 GMT https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960487#M978515 gautik92 2015-08-20T09:56:47Z Re: How to convert currency? https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960488#M978516 <HTML><HEAD></HEAD><BODY><P>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</P><P>The variable can then be used in your expression. </P></BODY></HTML> Thu, 20 Aug 2015 10:17:11 GMT https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960488#M978516 nigel987 2015-08-20T10:17:11Z Re: How to convert currency? https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960489#M978517 <HTML><HEAD></HEAD><BODY><P>Your solution here depends on how accurate you need your conversion to be.</P><P></P><P>For a simple conversion, apply a single rate based on a hard coded conversion rate or a variable.</P><P></P><P>For a more accurate conversion, load a table of exchange rates from a site such as xe.com - <A href="http://www.xe.com/currencytables/?from=INR&amp;date=2015-08-20" title="http://www.xe.com/currencytables/?from=INR&amp;date=2015-08-20">Autoextraction Prohibited</A> -</P><P></P><P>Then match the date to the date your transaction relates to and apply the conversion. </P></BODY></HTML> Thu, 20 Aug 2015 10:34:01 GMT https://community.qlik.com/t5/QlikView/How-to-convert-currency/m-p/960489#M978517 marcus_malinow 2015-08-20T10:34:01Z