topic Re: qvd file in Integration, Extension & APIs

qvd file

Anonymous — Sun, 12 Nov 2017 11:16:18 GMT

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 — Sun, 12 Nov 2017 11:54:41 GMT

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

swuehl — Sun, 12 Nov 2017 11:57:18 GMT

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

Anonymous — Mon, 13 Nov 2017 03:45:53 GMT

//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_g — Mon, 13 Nov 2017 04:39:10 GMT

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

Anonymous — Mon, 13 Nov 2017 05:13:45 GMT

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

Re: qvd file

shraddha_g — Mon, 13 Nov 2017 05:25:34 GMT

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

Re: qvd file

Anonymous — Mon, 13 Nov 2017 05:39:18 GMT

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

Re: qvd file

shraddha_g — Mon, 13 Nov 2017 06:20:07 GMT

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.

Re: qvd file

Anonymous — Mon, 13 Nov 2017 07:24:20 GMT

thanks...let mecheck this