Handling Currency Conversion & Daily Exchange Rates in Qlik View
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.