Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
,
,
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...
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.
here you find a qlik doc (see correct answer, John Withherspoon)