How to create the QVD files in QlikSense ? how to create lib

[#1]

tempdatestoretable:

LOAD Count(valuee) AS Followers, Floor(Today()) as StoreDate

RESIDENT ids;

CONCATENATE (tempdatestoretable)

LOAD *

FROM MyQVDTable.qvd (qvd)

WHERE Not Exists(StoreDate);

STORE tempdatestoretable INTO MyQVDTable.qvd (qvd);

DROP Table tempdatestoretable;

I want to create lib as MyQVDTable.qvd (qvd) gives invalid path

[oknotsen]

You create the library first. Next you add that before MyQVDTable.qvd.

store QVDloadExample into 'lib://Example sources/QVDloadExampleFile.qvd' (qvd);

[#3]

How to create the lib? can you please explain me step by step if possible. I have never created.

[oknotsen · Accepted solution]

In your script editor on the right hand side of your screen at the top you see a button "Create new connection". Click on it, select folder, and point it to the folder you want to store your QVDs.

If you do not see the button, click on the button in the top-right of your script editor to show the data connections.

The name you give this connection is the name of your "lib".

[#5]

[#6]

[#7]

tempdatestoretable:

LOAD Count(valuee) AS Followers, Floor(Today()) as StoreDate

RESIDENT ids;

CONCATENATE (tempdatestoretable)

LOAD *

FROM 'lib://libfolder/MyQVDTable.qvd' (qvd)

WHERE Not Exists(StoreDate);

STORE tempdatestoretable INTO 'lib://libfolder/MyQVDTable.qvd' (qvd);

DROP Table tempdatestoretable;

I have created a folder it is still giving me invalid path.

[oknotsen]

Does the folder actually exist?

Do you have permissions to create documents in that folder?

[#9]

I think i figured out the problem. the folder is on virtual machine. I am gonna try and solve it.

[#10]

it this lib connection proper?