Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

andymanu
Contributor

Storing a table as a QVD file

Hi,

I have loaded data into Qlik Sense using an excel file. The temporary name of the table is "Products"

Please refer the attached script.

Products:

LOAD

    Prod_ID,

    Prod_Name,

    "Date",

    Quantity,

    "Selling Price",

    Country1,

    Country2

FROM [lib://Product/Product Data.xlsx]

(ooxml, embedded labels, table is Sales);

The name of the excel sheet document is "Product Data" and the excel sheet name is "Sales" (which also can be seen from the "FROM" statement above).

The said excel document is saved in D:\Data folder.

I want to store the table as a qvd file in to a folder name Data inside the D: drive,

Thus, the path is "D;\Data"

I used the below script but it is popping up an error message stating, " connection not found D:"

STORE Products into [lib://D:\Data]Product Data].qvd;

I tried removing the D: as well but still unable to execute the script properly.

Appreciate a lot if you could help me to resolve this storing as a qvd file issue.

Thanks.

Regards,

Andy

7 Replies
charlie_firemind
New Contributor III

Re: Storing a table as a QVD file

Hey,

Reuse the existing connection if storing in the same directory.

STORE Products into [lib://Product/Product Data.qvd];

MVP
MVP

Re: Storing a table as a QVD file

Just as you or someone already created a connection called Products that is used in the load statement after the lib:// you will have to create a connection to the folder D:\Data and name it Data and then you can do someting like this:

STORE Products INTO [lib://Data/Product data.QVD] (qvd);

andymanu
Contributor

Re: Storing a table as a QVD file

Hi Petter,

Thanks for your reply. However, still I am getting an connection error.

, stating,

"Connection not found: Data"

I tried setting the Data folder permissions to "Modify" for everyone.

Thanking you in advance if you could help me to resolve the issue.

Thanks.

Andy



andymanu
Contributor

Re: Storing a table as a QVD file

Hi Petter,

Out of no where, I tried the below statement to store data and it worked,

"STORE Products INTO [lib://Product/Product Data.QVD] (qvd);"

It seems like a similar path to the fetching data has to be used despite the folder name where the original excel file was located.

Does it means that, when fetching the data from a particular location, Qlik Sense creates a path automatically and we have to use the same path to store the data?

However, thanks for your help and appreciate of you could clarify the above said suggestion.

Regards.

Andy

arvind1494
Contributor III

Re: Storing a table as a QVD file

Hi Andy,

first create new connection :

choose folder D://Data and give name to the connection as QvdStore

Now in your script do something like this

store Products into [lib://QvdStore/Products.qvd](qvd);

andymanu
Contributor

Re: Storing a table as a QVD file

Hi Petter,

Thank you so much for your feedback.

It helped me to understand the concept around the data connection.

Regards,

Andy

rangam_s
Contributor II

Re: Storing a table as a QVD file

STORE Products into [lib://Product/Product Data.qvd](qvd);


try this