Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Luminary
Luminary

Re: how to generate qvd files in qlikview?

Hi,

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

Store mytable into xyz.qvd (qvd);

Richard

MVP
MVP

Re: how to generate qvd files in qlikview?

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

Re: how to generate qvd files in qlikview?

thank you richard send qvd snipping file image to me

ger_alegria
Contributor

Re: how to generate qvd files in qlikview?

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.

Community Browser