Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ani310_mitra
Not applicable

Not Able to create QVD

Hi,

I am not able to create QVD.

While using only Data load script it is loading from Data base but while writing Store Command to Store QVD, it is giving error that "Connection not found" I have created a folder connection.

Please let me know any specific access required for the same??

Thanks

Anirban

7 Replies
danansell42
Not applicable

Re: Not Able to create QVD

Hi Anirban

Can you share the code you have for using the STORE command?

Maybe this is the issue...

It should be like the following:

Store Data into [lib://FOLDER/data.qvd](qvd);

Also, is the connection showing on the right hand side panel in Qliksense?

Dan

ani310_mitra
Not applicable

Re: Not Able to create QVD

Hi Daniel,

Connections are showing in the right panel in Qlik sense.

Please find below code.

LIB CONNECT TO 'DB_Test (ecommerce_amitra)';

LOAD "Ariba Code",
    "Level 1",
    "Level 2";
SQL SELECT "Ariba Code",
    "Level 1",
    "Level 2"
FROM "Procurement_DW".dbo."Category_Mapping";
Store Category_Mapping into 'lib://QVD_Data/QV1.QVD' (qvd);

I have created connection as QVD_Data.

While Loading it is giving an error,

Connection Not Found: QVD_Data.

Thanks and Regards

Anirban

danansell42
Not applicable

Re: Not Able to create QVD

The script looks ok...

If you go to the connection and click select data or edit connection does it bring up the correct folder?

ani310_mitra
Not applicable

Re: Not Able to create QVD

Hi Daniel,

Yes it is showing up the correct folder.

Thanks

Anirban

Khan_Mohammed
Not applicable

Re: Not Able to create QVD

Try this?


Store Category_Mapping into [lib://QVD_Data/Category_Mapping.qvd] (qvd);


Note you should have a table name in place before Load statement. Which I don't see in your code

ani310_mitra
Not applicable

Re: Not Able to create QVD

Hi Daniel,

Thank you for helping me.

Table name in place--> I not able understand the same.

Is anything else need to write over there, instead of what I mentioned.

Also I have tried above mentioned code, but still showing the same error.

Thanks

Anirban

Khan_Mohammed
Not applicable

Re: Not Able to create QVD

What folder destination you have?

Can you paste it here?

Ex: if you load a data from your Folder Connection, it will give you Lib.....

Can you provide that?

if possible give a screenshot of your script?

Connection not found is 'You did not set a connection and trying to save qvd in some other path.' if you have correct connection, it will store.

Or Create a new connection, extract some dummy data from that connection, it will provide with a script at the bottom.

From..... Lib

Copy only that lib part and use this code to store your connection and delete the dummy data script.

Thanks.