Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

reivax31
Contributor III

Partial Reload Sense Desktop Extension

Hi Qlikers,

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.

itHub - mhamano/Qlik-Sense-Reload-Button: Reload Button for Qlik Sense

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

1 Solution

Accepted Solutions
Employee
Employee

Re: Partial Reload Sense Desktop Extension

Hi Xavier,

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.

11 Replies
undergrinder
Valued Contributor II

Re: Partial Reload Sense Desktop Extension

Hi Xavier,

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.

Using QVD files for incremental load ‒ Qlik Sense

G.

kidbank3
Contributor III

Re: Partial Reload Sense Desktop Extension

Xavier,

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"

Mike

reivax31
Contributor III

Re: Partial Reload Sense Desktop Extension

Thanks for your answers.

I will try to do some optimisation in my script until we have access to partial relaod.

BR

reddys310
Honored Contributor II

Re: Partial Reload Sense Desktop Extension

HI Xavier,

Did you try the Limited Load option in the debugger mode?

Capture.PNG

Thanks,

Sangram.

reivax31
Contributor III

Re: Partial Reload Sense Desktop Extension

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.

Employee
Employee

Re: Partial Reload Sense Desktop Extension

Hello Xavier,

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.

Regards,

Mike Tarallo

Qlik

kidbank3
Contributor III

Re: Partial Reload Sense Desktop Extension

Xavier,

It sounds like you want an incremental load.  Partial reload means add/replace a table. 

Will incremental load not satisfy your needs?

Mike

reivax31
Contributor III

Re: Partial Reload Sense Desktop Extension

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.

BR

Xavier

gadwinjer
New Contributor III

Re: Partial Reload Sense Desktop Extension

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