I would like to know if it is possible to perform partial reload with QLIK SENSE DESKTOP?
I can only see a button "Load data" in Qlik Sense Desktop. I tried with the extension Qlik-Sense-Reload-Button but when I use the option "partial relaod" I get an error message.
Is there a special set up to build in order to make the extension work? Or Desktop version doesn't allow partial relaod anyway?
Thanks for your help
Solved! Go to Solution.
I have tested executing partial reload with Reload Button extension on Qlik Sense 2.2, and I faced no issues. Likely cause of the execution failure is that the load script itself is failing in execution. Please see reload log files stored on C:\Users\%username%\Documents\Qlik\Sense\Log to find out the errors of the reload script.
As far as I know the partial reload in Qlik Sense is possible only through API.
If you want to improve your reload speed, consider incremental load.
I've gotten around this issue by wrapping the tables I want to load in an if statement.
For example, create a variable, say "Set vTableName=1;". Then wrap the table you want to load in an if statement like
"if vTableName=1 then ...Load *...endif".
Set vTableName = 0 when you don't want the table to load and don't put a semicolon at the end of "endif"
Yes, I already tried this option. But still I have no way to trigger a partial reload with desktop version. So I have to reload millions of lines to add only a few thousands.
I informed the author of the partial reload issues with the button.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
What I want to do is to ADD data. But when I press the reload button all the tables are dropped. And I don't want to drop all the table. I juste want to add some extra data. The data I already have in my app is not changing so no need to reload it. I just want to add the daily new data.
So what I need is a function that will allow me to keep all the data I have in my app and add some fresh data.
Hello, you need to save your tables in QVD files, and then with a counter or a date value, compare the last value of your qvd file with the values you have to import. If it's newer, then you load, else you don't.
If you do this, you wont need partial reload button, the classical reload button will make the job well. Of course, if you change the structure of your modele, you will have to consider your qvds and incremental load again. There is many threads here that treat this case ! I had the same problem not long ago