Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
How to create qvd file.can you please help me with steps
and how to convert qvd into qvf
thanks
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.
You can create a QVD using a STORE statement.
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 .
//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
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
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
Did you try to degug and find out at which line you are getting this line?
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
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.
thanks...let mecheck this