must_include with a Sharepoint File location

[Crichter141]

In my load script I have a must include statement (onPrem) and it's not working.  The prior version worked but then the file was moved to a Sharepoint file location.  Can I use the Must_Include with a Sharepoint file location?

Is there something wrong in my syntax?  I have no spaces after the = sign.  

$(Must_Include=[lib://SharePoint_File/Shared Documents/Data Model Updates/Input Files/Variables/INCLUDE.txt]);

Qlik Sense answers only (no Qlikview, please).

Thank you in advance.

[Antoine04]

Hello,

Have you tried to replace the [ and ] characters by '

Is the connection to the sharepoint correct ?

Thanks

[Stefan5]

Hi, 

I have exactly the same problem. Does anyone have a solution? 

The connector is working with the sharepoint. As I want to load "Variables" I need to do this with includes. But is seems that the "MUST_INCLUDE" or "INCLUDE" does not work. The error is always, that the file could not be found

BUT - if I load the same file as "table" I can read the data without any problems (so the path is correct)

Example:

$(Must_Include='lib://Office_365_Sharepoint-svc_QlikCRMConnector/IT Qliksense Documents/APP_CONFIG_LOCAL_QVD01/00_includes/QS_Variablen1.txt');

Content of QS_Variablen1.txt (format UTF8 without BOM):
SET vRegion = 'Europe';
SET vYear = 2025;
LET vToday = Date(Today());

RESULT:

Der folgende Fehler ist aufgetreten:

$(MUST_INCLUDE= 'lib://Office_365_Sharepoint-svc_QlikCRMConnector/IT Qliksense Documents/APP_CONFIG_LOCAL_QVD01/00_includes/QS_Variablen1.txt'. qfilestream://IT Qliksense Documents/APP_CONFIG_LOCAL_QVD01/00_includes/QS_Variablen1.txt file not found.

Any ideas? Thanks, Stefan

[Crichter141]

I know this will sound silly, but try loading just your include file by itself, right after your SET statements.

When we pull our include file we have to do this the first time, sort of to set up Qlik to know it's there, if that makes sense.