topic Re: Refreshing a QVD in QlikView

Refreshing a QVD

ashwath26 — Wed, 25 Nov 2020 16:16:04 GMT

How to refresh a QVD File Incrementally/Full Refresh

YoussefBelloum — Thu, 21 Jun 2018 09:52:27 GMT

By loading it, making the necessary loads and re-store it (on the same path and name)

qlikviewwizard — Thu, 21 Jun 2018 09:53:58 GMT

Hi,

Check this.

ashwath26 — Thu, 21 Jun 2018 09:57:10 GMT

Please tell me if the following steps are right :

1) I have data till 31st June

2) I create a QVD using store into function. Name of .qvd is FIRST_QVD

3) I open a new QlikView file and for its source use FIRST_QVD

4) I am able to create viz using the data

INCREMENTAL :

On 1st July i get 100 new records. How do i incrementally add those to QVD Directly?

Or the only way is to do an incremental load first in edit script and re construct a new QVD?

YoussefBelloum — Thu, 21 Jun 2018 10:10:02 GMT

there is no single way to do this, it depends on your architecture.

to answer your question, how do yo store your new records ? on a new QVD ? how do you name the new QVD's ?

ashwath26 — Fri, 22 Jun 2018 07:09:35 GMT

Very useful. Thank you

ashwath26 — Fri, 22 Jun 2018 07:17:13 GMT

Thank you , very useful

qlikviewwizard — Fri, 22 Jun 2018 07:19:17 GMT

Please mark Correct Answer to close the thread.

Thank you.