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.
daisy1438
New Contributor

How to create Qvd in Qliksense?

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.

3 Replies
undergrinder
Valued Contributor II

Re: How to create Qvd in Qliksense?

Hi Daisy,

check this link:

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/...

For the error message: use the folder connection, not absolute path.

G.

agigliotti
Honored Contributor II

Re: How to create Qvd in Qliksense?

take a look at Create QVD in my desktop

I hope it helps.

balabhaskarqlik
Honored Contributor

Re: How to create Qvd in Qliksense?

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);

Community Browser