Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It reffering to a data connection created and stored in the App
See online Help
It reffering to a data connection created and stored in the App
See online Help
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...
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...
Many thanks to all of you for your quick answers!