Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
Next
Hope it helps
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.
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
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