Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikconsult
Partner - Creator
Partner - Creator

Qlik Sense Desktop: Load from path

Hi

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

10 Replies
Brossillon
Partner - Contributor II
Partner - Contributor II

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 :

 Annotation 2020-02-28 171651.jpg

 

But Qlik Sense does not allowed this connection.