topic Re: must_include with a Sharepoint File location in App Development

must_include with a Sharepoint File location

Crichter141 — Thu, 29 Feb 2024 15:26:28 GMT

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.

Re: must_include with a Sharepoint File location

Antoine04 — Thu, 29 Feb 2024 16:23:50 GMT

Hello,

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

Is the connection to the sharepoint correct ?

Thanks

Re: must_include with a Sharepoint File location

Stefan5 — Wed, 06 Aug 2025 14:15:27 GMT

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

Re: must_include with a Sharepoint File location

Crichter141 — Wed, 06 Aug 2025 14:18:23 GMT

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.