Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
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);
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
hi all,
I am not able to edit and create a folder to store the data into folder, please check the below screen shot.
any solution for this?
Regards,
Mike
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.
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.