Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pgrenier
Contributor 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

Re: Lib Keyword in Data load editor

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

4 Replies
Not applicable

Re: Lib Keyword in Data load editor

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

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

Employee
Employee

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

pgrenier
Contributor III

Re: Lib Keyword in Data load editor

Many thanks to all of you for your quick answers!