Handling Currency Conversion & Daily Exchange Rates in Qlik View

[#1]

Dear Members,

We are new to Qlik View, and are Implementing a Qlik View Dashboard, we are stuck with the Currency Conversion / Exchange Rate

The Transactional Data which comes from the Source System, has lines items in multiple currencies, which we have to convert into EURO Currency. The Daily Exchange Rates will be provided by the Client in an Excel Sheet. Can you please guide, as to how do we go ahead with this. We will get a new exchange rate file every day. Based on the Date in the Transaction Data, the system should fetch the exchange rates, and convert the other currency Values in EUROs. Can you please guide of these kind of standard Currency Conversions / Exchange Rates scenarios are being handled in Qlik View.

We found one thread, which talk about the exchange rates. http://community.qlik.com/thread/35248

But this doesnt talk about the date of exchange rates / daily / monthly exhange rates, as exchange rates will be different on different dates, in our scenario.

Regards

Pankaj

[Gysbert_Wassenaar]

Simply associate (or join) both tables on the date and currency fields.

[#3]

Hi Wassennar,

Can you please explain a little more. May be if you can provide a link to some documentation.

Regards

Pankaj

[Gysbert_Wassenaar]

Try here: http://www.qlik.com/us/services/training/free-training. Start with How Does QlikView Work and Build Your First QlikView

[#5]

But this doesnot talk about Currency conversion aspects. We have gone through that.

[Gysbert_Wassenaar]

Good. Then you now know how Qlikview associates tables. So, associate your exchange rates table and your transactions table on the data and currency fields.

[#7]

Normally, if you want the currency to change as time goes on you should change the source of currency (Excel file or database table) and then reload it to your QVW file.

You can try partial reload after changing your source data of currency (say 5.3 to 5.6).

There is another way, you can define the field 'Currency' as Variable or InputField.

Regards,

zhou