Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

QVD files

Dears

I was created a QVD files from a chart and save in my PC,Now if i want to update data to QVD files from my data base how it would be possibe

As i am new to this area please tell me what are the advantages of using QVD files

If we are working by using a QVW file it is enough or we need to make use of QVD file also

Faisal

Chennai

1 Reply
Miguel_Angel_Baeyens
Not applicable

Re: QVD files

Hi Faisal,

There are a lot of good documents and white papers on why use the QVD files and how. In regards to your question, I'd do a two step load, like the following:

// This loads the existing data in your QVD file

Original:

LOAD *

FROM File.qvd (qvd);

// This loads today data and appends its records

// to the table above

FromSource:

CONCATENATE (Original) LOAD *;

SQL SELECT *

FROM Database

WHERE Date = '20111220'; // Or whatever source or condition you use to get new records

// Now both the old data and today data are stored into the same QVD, so tomorrow

// the LOAD will be the same

STORE Original INTO File.qvd (qvd);

Hope that helps.

Miguel