Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

rupesh632
Contributor

qvd file

   Hi Team,

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

and how to convert qvd into qvf

thanks

9 Replies
Ralf_Heukäufer
Contributor III

Re: qvd file

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.

MVP
MVP

Re: qvd file

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 .

rupesh632
Contributor

Re: qvd file

//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

shraddha_g
Honored Contributor III

Re: qvd file

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

rupesh632
Contributor

Re: qvd file

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

shraddha_g
Honored Contributor III

Re: qvd file

Did you try to degug and find out at which line you are getting this line?

rupesh632
Contributor

Re: qvd file

Concatenate

LOAD

    Col1,

    Col2,

    update_date

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

(qvd);

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

comment concatenate then it works. what exactly does this concatenate

shraddha_g
Honored Contributor III

Re: qvd file

This concatenate keyword will concatenate Book11.qvd data to the previously loaded table.

If it doesn't find any table before keyword it will give you an error.

rupesh632
Contributor

Re: qvd file

thanks...let mecheck this

Community Browser