topic Re: How to create/implement a QVD file process in QlikView

How to create/implement a QVD file process

Tue, 25 Feb 2014 14:53:40 GMT

Does anyone have any basic instructions or how to docs on creating and/or implementing a QVD file process. This is my first attempt at the QVD process. I am looking to import 2013 data into a QVD file and not have it refreshed, just be a QVD file that is brought in. Going forward I am looking to create monthly QVD files for 2014 so I began creating trending charts based on historical data.

Re: How to create/implement a QVD file process

alexandros17 — Tue, 25 Feb 2014 15:02:53 GMT

You can do somethig like this:

for i = 1 to 12

myTab:

load * resident table where year = 2014 and month = $(i);

store * from myTab into myQvd$(i).qvd;

drop table myTab;

Hope it helps

Re: How to create/implement a QVD file process

Tue, 25 Feb 2014 15:06:57 GMT

HI there.. maybe you have to be more explicit in what you are trying to achieve.

To make a QVD file, you just import the data into your qvw using a

tablename;

load *

from (file)

and you can do a store of that into a file..

If you are looking for something more especific, please clarify your question.

Re: How to create/implement a QVD file process

pover — Tue, 25 Feb 2014 15:08:36 GMT

Hi Steve,

This part of the QlikView Help is pretty well documented. Just look for the section that is called "QVD files and Incremental Load" in QlikView Help. It details all the ways to do incremental loads using QVDs and example script.

Karl

Re: How to create/implement a QVD file process

Josh_Good — Tue, 25 Feb 2014 16:16:03 GMT

You may also want to check out this video Creating QVDs and Using the Store Function

or this more advance version Script for Incremental Loading of Multiple QVDs from a List of Table Names