Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to load data into qvd in qliksense?

Hi all,

            when i am loading the data from excel file i can create qvd using STORE ASCII into [lib://qvd/ASCII.qvd] (qvd);

but when i am loading from data base i am not able to store the data into qvd? is therre any solution for this?

Regards,

Mike

9 Replies
Not applicable
Author

Hi all,

The following error occurred:

Connection not found: SALES_DATA_SUMMARY.qvd

The error occurred here:

Store SALES_DATA_SUMMARY into [lib://SALES_DATA_SUMMARY.qvd] (qvd)

Regards,

Mike

Anonymous
Not applicable
Author

reddy-s
Master II
Master II

Hi Mike,

The error which you are getting is because of the connection. Its not with the syntax. When the connection fails, no data is retrieved and hence "Store SALES_DATA_SUMMARY into [lib://SALES_DATA_SUMMARY.qvd] (qvd)" statement would through an error because the table SALES_DATA_SUMMARY does not exist.

i would suggest you to check your data connection and make sure your connection string is embedded before the load statement.

If you can post the code which you are trying to execute, it would be easier to solve the issue.

Best Regards,

Sangram Reddy.

Not applicable
Author

hi Sangram Reddy,


This is the code

LIB CONNECT TO 'BUTAIMDBI02';

Sales_DATA_SUMMARY:

LOAD ID,

    CompanyID,

    CompanyName,

    CompanyType,

    State,

    City,

    Zip,

    sales,

SQL SELECT ID,

    CustomerID,

    CustomerName,

    CompanyType,

    State,

    City,

    Zip,

    sales

FROM StagingDB.dbo."Sales_DATA_SUMMARY";

Store INVOICE_DATA_SUMMARY into [lib://Documents/Qlik/qvd/Sales_sUMMARY.qvd](qvd);

Regards,

Mike

reddy-s
Master II
Master II

Hi Mike,

the load statement should end with  a semicolan.

Try this:

LIB CONNECT TO 'BUTAIMDBI02';

Sales_DATA_SUMMARY:

LOAD ID,

    CompanyID,

    CompanyName,

    CompanyType,

    State,

    City,

    Zip,

    sales ;

SQL SELECT ID,

    CustomerID,

    CustomerName,

    CompanyType,

    State,

    City,

    Zip,

    sales

FROM StagingDB.dbo."Sales_DATA_SUMMARY";

Store INVOICE_DATA_SUMMARY into [lib://Documents/Qlik/qvd/Sales_sUMMARY.qvd](qvd);

Not applicable
Author

hi Sangram Reddy,



i checked with a semicoln also



but error is

---

Started loading data

Connecting to BUTAIMDBI02

Connected

Sales_DATA_SUMMARY << Sales_DATA_SUMMARY

Lines fetched: 97,106

The following error occurred:

Connection not found: qvd

The error occurred here:

Store Sales_DATA_SUMMARY into [lib://qvd/Sales_DATA_SUMMARY.qvd](qvd)

Data has not been loaded. Please correct the error and try loading again.

Regards,

Mike

Not applicable
Author

hi all,

              I am not able to edit and create a folder to store the data into folder, please check the below screen shot.

Capture.PNG

any solution for this?

Regards,

Mike

reddy-s
Master II
Master II

Hi Mike,

Are you using QlikSense server, If so ask your administrator to give you access to do it. You need to have appropriate rights to do so.

reddy-s
Master II
Master II

Hi Mike,

Your script looks right to me. It could be the issue with the rights. I would suggest you to check with your server Admin if any rights are missing.