Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

currency translation as in SAP

Hi,

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

Thanks

Merlin

6 Replies
Not applicable

currency translation as in SAP

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 Geeked

Not applicable

currency translation as in SAP

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.

Not applicable

currency translation as in SAP

Hi,

This is very much possible in qlikview.

Check the attched application.

Happy Qliking Wink

-Peterson Geeked

amars
Valued Contributor

currency translation as in SAP

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

Not applicable

currency translation as in SAP

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.

Not applicable

currency translation as in SAP

Here you go.

Expression should be as follow.



Sum

([Sales Value]*Rate)



Community Browser