Organizations dealing in multiple currencies may use a web service to extract the exchange rates. They may even store the currency exchange rates in Excel files, or sometimes in a database table. The exchange rates for any currency may be stored only for each RateStartDate
, that, is for the day when the rate changes its value. However, for our reporting purposes, we need exchange rates for each day and not just for the day when the rate changes. For this purpose, it is beneficial to create an exchange rate calendar.
Create a new Qlik Sense application and load the following script into your Qlik Sense application:
ExchangeRatetemp: LOAD FromCurrency,ExchangeRate, DATE(Date#(RateStartDate,'DD/MM/YYYY')) as RateStartDate INLINE [ FromCurrency, ExchangeRate, RateStartDate EUR,0.687,01/08/2012 EUR,0.757,02/09/2012 EUR,0.74,08/09/2013 EUR,1.10,24/10/2014 SGD,0.52,01/08/2012 SGD,0.68,27/02/2014 SGD,0.88...