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