Using the Peek() function to create a currency exchange rate calendar

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.

Getting ready

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...