currency translation as in SAP

[#1]

Hi,

Is it possible to do currency translation as we do in SAP BW systems?

Thanks

Merlin

[#2]

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

[#3]

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.

[#4]

Hi,

This is very much possible in qlikview.

Check the attched application.

Happy Qliking

-Peterson

[amars]

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

[#6]

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.

[#7]

Here you go.

Expression should be as follow.

Sum

([Sales Value]*Rate)