Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Lib Keyword in Data load editor

Good morning,

I have noticed the use of the Lib:// keyword in the data load script for Executive Dashboard example app that was delivered along with Qlik Sense. Here is an example of its use:

AccountMaster:

LOAD Account, AccountGroup

FROM 'lib://Executive Dashboard Data/AccountMaster.qvd' (qvd);

Any ideas as to what it refers to? Does it correspond to a server defined file repository?

Thanks in advance for your time, regards,

Philippe

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Lib Keyword in Data load editor

4 Replies
Highlighted
Not applicable

Re: Lib Keyword in Data load editor

Highlighted
Employee
Employee

Re: Lib Keyword in Data load editor

I replied on a similar question here: Re: lib in data load editor

In short;

Stefan Bäckstrand wrote:

The LIB keyword is to reference to a datasource by name, that has been created by you (or shared to you?), like this:

LIB CONNECT TO 'MyDataSource';

LOAD *;

SQL SELECT * FROM `Sales_data`;

The other use of lib is when referring to a library as a folder (or similar), like this:

LOAD * FROM 'lib://PublicData' (html, table is @1);

[..] You could expect that this is something to look out for in the continuation of Qlik Sense later this year, without saying to much.

More information: http://help.qlik.com/sense/en-US/online/index.html#../Subsystems/Qlik_Sense_Desktop_help/Content/Loa...

Highlighted
Support
Support

Re: Lib Keyword in Data load editor

Hi Philippe,

It refers to a Folder Data Connection. So if you in Sense create a Folder Data Connection, you can later reference files in this folder using the name of the connection (in this case 'Executive Dashboard Data'). In this way you isolate direct access to the file system. It may not be that much of interest when running locally in desktop (why bother, when I can just simply use Windows Explorer to access data anyway?), but when deployed on a server, the server admin can define Folder Data Connections, preventing users from gaining direct access to the file-system, but still get hold of data required for building apps.

For more information about lib://, see https://help.qlik.com/sense/en-us/online/index.html#../Subsystems/Qlik_Sense_Desktop_help/Content/Lo...

Highlighted
Partner
Partner

Re: Lib Keyword in Data load editor

Many thanks to all of you for your quick answers!