Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pgrenier
Partner - Creator III
Partner - Creator III

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
Not applicable

4 Replies
Not applicable

It reffering to a data connection created and stored in the App

See online Help

https://help.qlik.com/sense/en-US/online/index.html#../Subsystems/Qlik_Sense_Desktop_help/Content/Lo...

StefanBackstrand
Partner - Specialist
Partner - Specialist

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...

Bjorn_Wedbratt
Former Employee
Former Employee

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...

pgrenier
Partner - Creator III
Partner - Creator III
Author

Many thanks to all of you for your quick answers!