convert into currency

[#1]

hi,

how to convert INR into Dollor

or

Dollor into INR and so on.

[Anonymous]

It depends on what you want to do. For one value.. 1 USD is roughly 45 INR. However, if you have historic figures and want to convert according to the exchange rates at the time of the transaction, you'll have to load a list of historical conversion rates and apply accordingly.

[suniljain]

Dear Rajni,

There are lots of blog exist in which detaile discussion on Curreny conversion happend.

pls visit.

http://community.qlik.com/forums/t/38309.aspx

[amars]

Hi Rajani,

You can create an Inline table or a table in ur DB which will have a structure like this

FromCurrency ToCurrency ConversionRate

INR USD 0.02863

USD INR 45.67

Now in this structure ur FromCurrency represent the transaction currency . ToCurrency is the currency in which u want to see the amount in and ConversionRate is the conversion rate. Now if u have multiple ToCurrencies in ur conversion table u can keep the Tocurrency Field as Always one value selected checked. & to see the desired result can write a expression like TransactionAmount * ConversionRate.

Hope this helps.

Thanks

[suniljain]

Inline does not work in real life scenario, because currency rate is dynamic in nature and it change every day.

so you have to extract currency rate from web site like xe.com,oenda.com and store it in QVD .

you can use that QVD for currency conversion purpose.