Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

1 Solution

Accepted Solutions
Not applicable

execute store statement only on non-partial reload


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


4 Replies
Not applicable

execute store statement only on non-partial reload


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


Not applicable

execute store statement only on non-partial reload

That should really be:

If not IsPartialReload() then

...

Luminary
Luminary

execute store statement only on non-partial reload

Hi,

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

Stephen

Not applicable

execute store statement only on non-partial reload

Thanks a lot, Tim and Stephen.

It works perfect!

Community Browser