Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How to create the Qvd in Qliksense .I know how to create in Qvd in Qlikview but when I am trying to create Qvd in qliksense it showing below error.
error: this statement only works with lib:// path in this script mode.
Hi Daisy,
check this link:
For the error message: use the folder connection, not absolute path.
G.
take a look at Create QVD in my desktop
I hope it helps.
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:
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);