Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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
Partner - Contributor

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.