qvd file

[Anonymous]

   Hi Team,

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

and how to convert qvd into qvf

thanks

[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.

[swuehl]

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 .

[Anonymous]

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

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

[Anonymous]

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]

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

[Anonymous]

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]

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.

[Anonymous]

thanks...let mecheck this