Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to do currency translation as we do in SAP BW systems?
Thanks
Merlin
Hi,
Qlikview will be able to do currency translation but i`m not sure how SAP BW do this. can you pl elaborate a bit so that i can understand the scenario and tell how to do the same in Qlikview.
-Peterson
Hi Kevin
In SAP BW we do currency translation by the following way.
we have the conversion rate maintained for each currency in a table.
So when we have a value say 10$ and the conversion rate for USD to INR is 40 for example.
Then the value should be displayed as 400INR.
Hope you understood this.
Hi,
This is very much possible in qlikview.
Check the attched application.
Happy Qliking
-Peterson
Hi,
You can do it in a similar way in Qlikview. You can create a table in this format
FromCurrency, ToCurrency, ConversionRate
Where FromCurrency :- Transaction Currency (make a join in qlikview by giving a common alias)
ToCurrency :- The Currency in which u wish to see the values
ConversionRate :- the conversionrate from From to To Currency.
Give a selection of ToCurrency to the use , so a use can select a value at any moment. Select a single value & in List properties select the property "Always one value selected" so a user is able to see the values in only a single currencies at a time & put a formula like Sales Amount * ConversionRate .
Hope this helps
With Regards
Amar
Hi Amar
I will try your solution and let know in case of any issues.
Peterson,
I am not able to view the file which u had sent. I am using a trial version of the Qlikview.Can you please send me the screenshot of the same.
Thanks for your responses.
Here you go.
Expression should be as follow.
Sum
([Sales Value]*Rate)