Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

drose4802
New Contributor II

Decrease Load time

I have 6 different Excel files in my LOAD statment for QlikSense which are all used for various charts inside the app. 3 of these files are static (i.e. historical information). How can I design the load script to load the historical data once and only reload the other 3 files when I execute the load script. I am trying to reduce the overall script loading runtime but have all the data from all six files.

1 Reply

Re: Decrease Load time

Hi,

You can create one qvf which will hold the historical data. Call that as HistoricalDataApp.

Then you create a regular qvf and then do a binary load of the HistoricalDataApp and rest script will have only the excels from where you need regular data.

This way you will reduce the loading time of the app.

Regards,

Kaushik Solanki

Community Browser