topic Re: Qlik Sense Desktop: Load from path in App Development

Qlik Sense Desktop: Load from path

qlikconsult — Mon, 22 Sep 2014 15:19:02 GMT

In Qlik Sense Desktop 0.96 I was able to load an excel file using a variable for the path

let vFolderPath = 'C:\MasterFiles\';

Table1:

LOAD *

FROM $(vFolderPath)MyFile.xlsx (ooxml, embedded labels, table is Sheet1);

I upgraded to Qlik Sense Desktop 1.0.0 Build 21.ms8 and when I reload this now I get the following error message:

LOAD statement only works with lib:// paths in this script mode

So my question is:

From Qlik Sense Desktop version 1 onwards, must you create a Folder Data Connection?

Is there still a way to load a file using a FROM statement with a variable pointing to the path (rather than using a folder connection library). The reason I'm asking this is because when I share a app to another user I want to allow the user to simply change the path in the variable (use a trick or two for this to minimize user input) to allow that user to also load data from a file without having to edit the folder connection

Re: Qlik Sense Desktop: Load from path

ToniKautto — Mon, 22 Sep 2014 18:37:19 GMT

Yes, you must use Lib paths for your data sources.

Notice that the Lib refers to a connection name, not the actual file path. This means that when opened on an other machine, the developer can simply change the folderpath in the preferred Lib and it will apply on all references to that Lib.

Re: Qlik Sense Desktop: Load from path

Anonymous — Mon, 22 Sep 2014 22:44:26 GMT

Hi Jan-Hendrik,

I have experienced the same issues with my 0.96 Qlik Sense apps as well. What I did for a work around for version 1.0 was to create a Lib path for the data sources, and modified the script variable to accommodate the new change.

Example:

Create a new Folder Data Connection in the script editor that points to the master files and give it a name. (For this case, we'll call the connection "FilePath")

Replace the LET command in the beginning of your script with this new description:

LET vFolderPath = 'lib://FilePath/';

That's it! No need to change any of the original table loads if they are all using the vFolderPath variable in the FROM statements.

Cheers,

Sean

Re: Qlik Sense Desktop: Load from path

qlikconsult — Tue, 23 Sep 2014 08:21:10 GMT

Thx guys!

Re: Qlik Sense Desktop: Load from path

jrdunson — Mon, 06 Jun 2016 12:07:44 GMT

To follow up, what if my files are stored on a different drive (i.e. drive mapping?) - How do I define it with 'Lib' ?

LET vFolderPath = 'D://FilePath/';

Re: Qlik Sense Desktop: Load from path

jrdunson — Mon, 06 Jun 2016 12:08:33 GMT

that is, the drivepath is for a different machine, not under my C: drive

Re: Qlik Sense Desktop: Load from path

qlikconsult — Tue, 07 Jun 2016 13:07:56 GMT

Suggest you create a new folder connection and then type in the mapped drive (press enter after typing in mapped drive)

then defining variable in same way

Re: Qlik Sense Desktop: Load from path

jrdunson — Tue, 07 Jun 2016 18:02:45 GMT

Jan,

Hey, thanks for the feedback... that gets me half-say, Qlik Sense can logically see the files... in my QVD directory.

It can even create the load script...

LOAD

"Field1",

"Field2", .... etc.

FROM [lib://X/corebio.qvd] (qvd);

However, when I run this, I get:

I have also tried:

LOAD * from 'X:\corebio.qvd' (qvd)

LOAD * from 'X:\\corebio.qvd' (qvd)

LOAD * from 'X:\Custom\corebio.qvd' (qvd)

LOAD * from 'X:\\Custom\corebio.qvd' (qvd)

Here is my Path definition:

... etc, more .qvd files... corbio.qvd, etc.

Re: Qlik Sense Desktop: Load from path

undergrinder — Wed, 08 Jun 2016 07:06:34 GMT

Hi Jarell,

Be careful, if you are using Qlik Sense Server Edition, the username will be added to data connection name automatic.

If you want use absolute path instead of lib connection you should disable the standard mode.

Disabling standard mode ‒ Qlik Sense‌

Re: Qlik Sense Desktop: Load from path

SunilChauhan — Fri, 03 Aug 2018 10:16:06 GMT

In simple worlds Creating a folder by providing the path

from script editor-> Create new connection-> Give the name and path of folder here

then fetch excel from the connected folder

it will auto take Lib path.

Re: Qlik Sense Desktop: Load from path

Brossillon — Fri, 28 Feb 2020 16:19:35 GMT

I have the same question.

LET vDir = 'C\Users\' '\Documents';

And then I would like to create a data connection with this path

For exemple :

But Qlik Sense does not allowed this connection.