Check these:
Create a library or Connection, for where you want to store the QVD, for instance named "QVDFolder" (right side panel in the data load editor)
Use this command to store:
STORE TableName INTO [lib://QVDFolder/TableName.QVD] (qvd);
When the connection fails, no data is retrieved and hence, through an error because the table does not exist.
I would suggest you to check your data connection and make sure your connection string is embedded before the load statement.
OR
You can disable Standard Mode to use the appropriate file paths as used in QlikView
Check this:
https://help.qlik.com/en-US/sense/1.0/Subsystems/WorkingWith/Content/LoadData/DisableStandardMode.ht...
Try Like 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 Sales_DATA_SUMMARY into [lib://Documents/Qlik/qvd/Sales_Summary.qvd](qvd);
Load data like this, after library creation:
Requests:
LOAD
%OwnerId,
Case_Date_Key,
"Date",
Subject,
"Case Owner",
"Case Owner Group",
"Employee Hire Date",
"Employee Status"
FROM [lib://Helpdesk Management Data Files/chuck/QS Requests.qvd](qvd);
