Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

execute store statement only on non-partial reload

Hi all

We're creating a QVD file using STORE statement in non-partial reload. After that, we do a partial-reload to add new tables (we use "replace only" statement). The STORE statement executes again on partial-reload.

I've looked into the reference manual and it says only "store" or "add" statements are executed on partial-reload, but STORE is executing and updating data on QVD file... How could I ignore the STORE statement on the partial-reload?

I've attempt creating a temporary table, store temporary table into QVD and drop that table on "normal" reload, but it causes execution error during partial-reload.

Thanks.

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author


If IsPartialReload() then
Store mytable into myfile.qvd;
End If


View solution in original post

4 Replies
Not applicable
Author


If IsPartialReload() then
Store mytable into myfile.qvd;
End If


Not applicable
Author

That should really be:

If not IsPartialReload() then

...

stephencredmond
Partner - Specialist II
Partner - Specialist II

Hi,

Use the IsPartialReload() command within an IF..END IF to control the STORE.

Stephen

Not applicable
Author

Thanks a lot, Tim and Stephen.

It works perfect!