Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

FULL and COMPLETE syntax for INCLUDE statement

Trying to use this as we are changing db configurations, and I want to keep all the connections in separate Include files, so that I only need to update them once.

I entered in my script:

$(include = R:\IncludeFiles\ActivityDB.txt);

It showed up in italics, with the entire line underlined in red (usually indicates an error!).

Wasn't recognized - that is, script threw up errors that it couldn't access the db

Tried $(Must_Include = R:\IncludeFiles\ActivityDB.txt);; Got the message "Connection failed"

Two things: What is the correct syntax for this command? I followed what was shown in the Help file exactly. Does it need to be

prefaced with something (e.g. the "OLEDB Connect"?).

Second: if anyone from QlikTech is reading this, PLEASE, PLEASE update your documentation search engine!! I suggest that someone try searching for "Include" or "$(Include" or anything, and getting a meaningful result from the search engine. It was only when I tried to search for "Must_Include" that I found the entry.

1 Solution

Accepted Solutions

Re: FULL and COMPLETE syntax for INCLUDE statement

remove spaces before and after =

$(Include= R:\.......);

I do not know if R drive is recognized, tri with a syntax like

$(Include=..\_Common Code\Source\Variables Main.txt);

Let me know

2 Replies

Re: FULL and COMPLETE syntax for INCLUDE statement

remove spaces before and after =

$(Include= R:\.......);

I do not know if R drive is recognized, tri with a syntax like

$(Include=..\_Common Code\Source\Variables Main.txt);

Let me know

Not applicable

Re: FULL and COMPLETE syntax for INCLUDE statement

Hi Alessandro,

Thanks very much! Worked perfectly!

Community Browser