Picture a scenario where the month end sales data in an organization is stored in a folder on the network from where it needs to be picked up for reporting purposes. Control statements such as For Each next can be used in Qlik Sense as an approach toward script iteration. The following recipe deals with extracting files in Qlik Sense from a folder, processing them to create QVD files, and then transferring the source files to another folder. In the process, we will also deal with the incremental update of the QVD.
This recipe requires the legacy mode to be activated. The steps are as follows:
- To activate the Legacy mode, open the
Settings.ini
file underC:\Users\<username>\Documents\Qlik\Sense
. - Change the value of the
StandardReload
parameter from1
to0
. - For this recipe, we make use of four Excel files:
January.xlsx
,February.xlsx
,March.xlsx
, andApril.xlsx
. These files are provided with the chapter and can be downloaded...