I dont think that you can use Reload and Partial Reload simultaneously.
But you can use in two steps,
First reload the application and on successful completion of this task execute another task of partial reload.
Please explain in brief regarding your requirement, so that we can think of any alternative solution.
Thank you for your reply!
We're trying to lower CPU usage through some optimization.
For example, it's enough to load section access tables once a day, while ledger transactions statistics should be reloaded every 5 minutes.
Normally, Section Access doesn't take much resources, but for one particular report it's rather heavy.
The problem is that the flag 'Partial Reload' refers to all tasks in QEMC
You can restrict a portion to load on particular time like .if you want section to load at morning 10 am then you can restrict using
if(time(Today())='10:00:00' ) then // you can check the format of time
i thing its better idea to restrict it at one time in a day.
hope this make sense
Store your section access data in QVD and then load it during Normal reload, a qvd file is loaded much faster than database or some files. I think this is the better option it won't take much time to load.
In QVD generation file just use if condition to restrict the generation of QVD or you can create new qlikview file for generating section access qvd file and schedule it to reload every hour.
Hope it helps you.
Maybe you should have a look at performing Incremental Loading.
On average, loading a section access table isn't taking much time. But refreshing transaction tables in whole is. Since transaction tables have a tendency not to forget (they keep history), you could devise a technique to load only the additions every 5 minutes.
There are lots of discussions about Incremental LOADs. You can get started with Incremental Load.docx.