Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
drose4802
New Contributor II

Reduce Load Time

I have 3 separate Excel files with data (2015,2016,2017). My load statement in Qlik Sense loads from each of the files. The only file that is continually changing is 2017. In an effort to reduce load time, how do I load 2015 and 2016 files once and only spend time loading new 2017 data?

3 Replies

Re: Reduce Load Time

1. Create QVDs of 2015,2016 and read data from this qvds.

2. Only load new data fro the 2017 qvds.

mark6505
Valued Contributor III

Re: Reduce Load Time

HI David,

As Anand has suggested. Storing the data for 2015 and 2016 into qvds.

If you take your original script for 2015 and 2016, and a store command to save it to QVD.

Like Store 2015 into lib://'Your library'\2015.qvd;   (Your library be where you want them ).

Once in QVDs, you can just load using there as your source and you should see a big difference in load times.

Also maybe worth looking at the Incremental load logic if you 2017 file is very large.

MArk

Khan_Mohammed
Honored Contributor II

Re: Reduce Load Time

You cannot load it only once if you want to see 2015 and 2016 data always.

You have to reload these qvd's always along with 2017 data.

Or try Incremental load but as far as I know data cannot be stored if there is no table in qvw.

Community Browser