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:
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,
Solved! Go to Solution.
I replied on a similar question here: Re: lib in data load editor
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';
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.
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...