4 Replies Latest reply: Apr 10, 2014 12:50 PM by Gerardo Alegria Benitez RSS

    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

        • Re: how to generate qvd files in qlikview?
          Richard Pearce

          Hi,

           

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

           

           

          Store mytable into xyz.qvd (qvd);

           

           

          Richard

          • Re: how to generate qvd files in qlikview?
            Massimo Grossi

            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.

            • Re: how to generate qvd files in qlikview?
              Gerardo Alegria Benitez

              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.