topic convert into currency in QlikView

convert into currency

Thu, 03 Mar 2011 07:29:26 GMT

hi,

how to convert INR into Dollor

Dollor into INR and so on.

convert into currency

Anonymous — Thu, 03 Mar 2011 07:32:44 GMT

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.

convert into currency

suniljain — Thu, 03 Mar 2011 07:37:30 GMT

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

convert into currency

amars — Thu, 03 Mar 2011 07:45:36 GMT

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

convert into currency

suniljain — Thu, 03 Mar 2011 08:23:26 GMT

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.