CURRENCY FORMATE

[#1]

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

[giakoum]

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?

[#3]

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

,

,

[giakoum]

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...

[srchilukoori]

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.

[maxgro]

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

Currency Conversion