Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to generate qvd files in qlikview?

hi guys

I want to generate QVD files in qlikview ,I do not know how to generate QVD files in qlikview files please tell me out.and send to me some examples please.

Regards:

madhu

4 Replies
richard_pearce6
Luminary Alumni
Luminary Alumni

Hi,

All you have to do it load the table then use the STORE command

Store mytable into xyz.qvd (qvd);

Richard

maxgro
MVP
MVP

search in online help qvd, this is just an extract

Create QVD Files

A QVD file can be created by one of three different methods:

  1. Explicit creation and naming using the Store command in the QlikView script. Simply state in the script that a previously read table or part thereof is to be exported to an explicitly named file at a location of your choice.
  2. Automatic creation and maintenance from script. By preceding a load or select statement with the Buffer prefix, QlikView will automatically create a QVD file which under certain conditions can be used instead of the original data source when reloading data.
  3. Explicit, manual creation and naming from layout or via Internal Macro Interpreter. Data can be exported from the QlikView layout via GUI commands or Automation macros. In the GUI you will find QVD as one of the possible export formats under the Export... command, found on the object menu of most sheet objects.

There is no difference between the resulting QVD files, e.g. with regard to reading speed etc.

Not applicable
Author

thank you richard send qvd snipping file image to me

ger_alegria
Partner - Creator
Partner - Creator

Hi,

Generate QVD files is really easy. All you have to do is load the table you want to save into a qvd file and then with the STORE command write the qvd file.

Example:

Table:

LOAD

        A,

        B,

        C

From XYZ.csv;

Store Table into ExampleQVD.qvd;

There are other methods to generate a QVD file but the STORE command is one of the most used.