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

Script Error

The following error occurred:

This statement only works with lib:// paths in this script mode

The error occurred here:

Data: LOAD * FROM (qvd)

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

Note: Title edited by community moderator for brevity.

Tags (1)
2 Replies
jaimeaguilar
Valued Contributor II

Re: Script Error

Hi,

this is happening because in this case syntaxis is slightly different in QlikView and Qlik Sense.

In QlikView you can load data with the following syntax LOAD * FROM (qvd)

However, this will not work in Qlik Sense, because Sense introduces the concept of libraries. In Sense every data source is a connection. In data load editor, in the right part you will find your connections (it can be pretty much anything: a folder, an oledb/odbc connection, etc). Here you create a new connection, selecting folder as type and then you just have to find the needed folder within your files.

So basically the difference between QlikView and Qlik Sense is that in View you make reference either to the full path or to a relative path without having to configure a connection. In sense you have to create the connection to the folder and when you load data you make reference to the connection name (with the lib: part) instead of the file path, so it would be like this:

LOAD * FROM [lib:\\YourFolderConnection\*.qvd] (qvd)


hope this helps,


kind regards

tomasz_tru
Valued Contributor

Re: Script Error

Create new data connection and link it to the folder instead of using absolute path.

Community Browser