topic Re: Include statement - in Qlik Sense in App Development

Include statement - in Qlik Sense

jcampbell — Mon, 24 Nov 2014 19:11:33 GMT

Mike,

I'm using an Include in Data load editor but it's generating an error. This is the syntax I'm using:

$(Include=Load-Script.txt);

Attached is the error Qlik Sense is generating. Is the syntax correct?

Thanks,

Josh

Re: Include statement - in Qlik Sense

Michael_Tarallo — Mon, 24 Nov 2014 19:16:26 GMT

Hi Joshua - check this out:

Disable Standard Mode -

BTW - Are you using Qlik Sense Server or Desktop?

In Qlik Sense, by default file access is disabled via paths (and requires the use of the LIB statement and a creation of a Folder connection).

Here is an example - LIB and Include

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike

Re: Include statement - in Qlik Sense

jcampbell — Mon, 24 Nov 2014 19:29:10 GMT

Server.

Re: Include statement - in Qlik Sense

jcampbell — Mon, 24 Nov 2014 20:06:32 GMT

Michael,

I've created the data connection and I believe this syntax is correct:

$(Include=lib:\\Scripts (keystone_keystoneapp3)\DEMO\Load-Script.txt);

It is still generating the same error. Any ideas?

Thanks,

Josh

Re: Include statement - in Qlik Sense

Michael_Tarallo — Mon, 24 Nov 2014 21:55:37 GMT

Hi Joshua - I'll build out a sample for you - but perhaps my colleague Jonathan Poole - might be able to assist if he is available.

Jonathan if you have a moment, can you take a look at this?

If not - I will look at, once I am off my call.

Mike

Re: Include statement - in Qlik Sense

JonnyPoole — Tue, 25 Nov 2014 00:40:24 GMT

Josh - try reversing the direction of your slashes . You'll get the error with back slashes but not forward ones.

$(Include=lib://Scripts (keystone_keystoneapp3)/DEMO/Load-Script.txt);

Re: Include statement - in Qlik Sense

jcampbell — Tue, 25 Nov 2014 13:26:46 GMT

Jonathan,

That did the trick. Thanks!

Josh