9 Replies Latest reply: Nov 13, 2017 2:24 AM by Rupesh Shelar RSS

    qvd file

    Rupesh Shelar

         Hi Team,

      How to create qvd file.can you please help me with steps

      and how to convert qvd into qvf

       

      thanks

        • Re: qvd file
          Ralf Heukäufer

          Hi Rupesh,

           

          a QVD file is created by the use of a “Store” statement in your load script. The format should be as follows:

           

           

          Store [your table name] into ..\ [File Path you created as source in your Qlik application as source] \ [Name of your QVD].qvd;

           

          Normally you drop your table after that with "Drop Table [Name of your Table]".

           

          You can´t convert a qvd in a qvf.

          A qvd is a special Tableformat from Qlik for fast reading.

          A qvf is a File with your complete app include the Data and the visualisations.

          • Re: qvd file
            Stefan Wühl

            You can create a QVD using a STORE statement.

            Store ‒ Qlik Sense

             

            A QVD stores a single table, while a QVF stores a complete data model containing possibly many tables, the script to build the model and the front end visualization.

             

            The script may contain LOAD statements to load data from QVD(s).

            No need to convert a QVD. Just load the data into the model .

              • Re: qvd file
                Rupesh Shelar

                //increamental

                // LOAD

                //     *

                // FROM [lib://Binaryloads/Book1.xlsx]

                // (ooxml, embedded labels, table is Sheet1)

                // Where update_date>today();

                // //Store qvd

                 

                 

                // store Sheet1 into lib://Binaryloads/Book11.qvd;

                 

                 

                //load from qvd

                 

                 

                Concatenate

                 

                 

                LOAD

                    Col1,

                    Col2,

                    update_date

                FROM [lib://Binaryloads/Book11.qvd];

                store Sheet1 into lib://Binaryloads/Book11.qvd

                 

                i got error in  loading data from qvd file...says col1 is not recognized

                  • Re: qvd file
                    Shraddha Gajare

                    Try,

                     

                    //increamental

                    // LOAD

                    //     *

                    // FROM [lib://Binaryloads/Book1.xlsx]

                    // (ooxml, embedded labels, table is Sheet1)

                    // Where update_date>today();

                    // //Store qvd

                     

                     

                    // store Sheet1 into lib://Binaryloads/Book11.qvd;

                     

                     

                    //load from qvd

                     

                     

                    Concatenate

                     

                     

                    LOAD

                        Col1,

                        Col2,

                        update_date

                    FROM [lib://Binaryloads/Book11.qvd]

                    (qvd);

                     

                    store Sheet1 into lib://Binaryloads/Book11.qvd

                      • Re: qvd file
                        Rupesh Shelar

                        getting this error

                        The following error occurred:

                        -1 =

                        The error occurred here:

                        ?

                        Data has not been loaded. Please correct the error and try loading again.

                         

                        Adding steps from starting

                        // tech:

                        // LOAD

                        //     Col1,

                        //     Col2,

                        //     update_date

                        // FROM [lib://Binaryloads/Book1.xlsx]

                        // (ooxml, embedded labels, table is Sheet1);

                        // store tech into lib://Binaryloads/Book11.qvd;

                         

                         

                        //increamental

                        // LOAD

                        //     *

                        // FROM [lib://Binaryloads/Book1.xlsx]

                        // (ooxml, embedded labels, table is Sheet1)

                        // Where update_date>today();

                        // //Store qvd

                         

                         

                        // store Sheet1 into lib://Binaryloads/Book11.qvd;

                         

                         

                        //load from qvd

                         

                         

                        Concatenate

                         

                         

                        LOAD

                            Col1,

                            Col2,

                            update_date

                        FROM [lib://Binaryloads/Book11.qvd]

                        (qvd);

                         

                        store tech into lib://Binaryloads/Book11.qvd