topic Re: CURRENCY FORMATE in QlikView

CURRENCY FORMATE

Sun, 23 Mar 2014 15:46:44 GMT

Hi Friends ,

i need to change my sales data like INR,USD, OR JPY......Can any body help

i have data like below

prodname,sales currency

nokiya , 100 inr

cellcone , 200 usd

sumsung , 300 eur

jpy

gpb

Re: CURRENCY FORMATE

giakoum — Sun, 23 Mar 2014 15:53:32 GMT

you need to change every value in your sales data to the currencies or every value in the data is of different currency?

If the 1st is the case, what base currency is your sales data?

If the latter is the case, is there a column in sales data with currency information?

Re: CURRENCY FORMATE

Sun, 23 Mar 2014 17:55:12 GMT

Hi loannis thanks for your repley,

i need change every value in the data is of different currency format's when am clicking particular currency

like,when am clicking

ex: euro ,all sales data shows in euro

ex: usd ,all sales data shows in usd

i need this type of Req,,,please

Thank you

Re: CURRENCY FORMATE

giakoum — Sun, 23 Mar 2014 18:30:43 GMT

then you need to know the base currency of your sales data. for example what is 100 in record nokiya , 100 ? USD, EUR, what is it? And then you need the exchange rates for every currency. Do you have those? Or will you use the internet for example to source them? In this case you need a web service. Information how to use a web service in QV can be found here : http://community.qlik.com/docs/DOC-1320

A popular currency web service is this : http://www.xe.com/currencyconverter/convert/?Amount=100&From=AFN&To=ALL

So it all depends what your requirement is and what data you have available

unless you mean that you want to show the SAME value in eur or usd format, which does not make much sense to me...

Re: CURRENCY FORMATE

srchilukoori — Sun, 23 Mar 2014 19:37:18 GMT

If you have a currency field in the table, you can use the exchange rates to convert the sales to all the required currencies.

Prodname, Sales, Currency

nokiya, 100, INR

cellcone, 200, USD

samsung, 300, EUR

Use the exchange rates to create new fields Sales (USD), Sales (EUR) etc.

Re: CURRENCY FORMATE

maxgro — Sun, 23 Mar 2014 20:04:14 GMT

here you find a qlik doc (see correct answer, John Withherspoon)

Currency Conversion