Partial Reload Sense Desktop Extension

[reivax31]

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

[undergrinder]

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.

[mgranillo]

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]

Thanks for your answers.

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

BR

[reddy-s]

HI Xavier,

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

Thanks,

Sangram.

[reivax31]

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.

[Michael_Tarallo]

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

[mgranillo]

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]

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]

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