topic currency translation as in SAP in QlikView

currency translation as in SAP

Tue, 18 May 2010 09:11:00 GMT

Hi,

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

Thanks

Merlin

currency translation as in SAP

Tue, 18 May 2010 10:09:37 GMT

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

currency translation as in SAP

Tue, 18 May 2010 10:28:52 GMT

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.

currency translation as in SAP

Tue, 18 May 2010 10:45:07 GMT

Hi,

This is very much possible in qlikview.

Check the attched application.

Happy Qliking

-Peterson

currency translation as in SAP

amars — Tue, 18 May 2010 10:49:48 GMT

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

currency translation as in SAP

Tue, 18 May 2010 11:00:31 GMT

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.

currency translation as in SAP

Tue, 18 May 2010 11:05:42 GMT

Here you go.

Expression should be as follow.

Sum

([Sales Value]*Rate)