Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Partner - Champion III
Partner - Champion III

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

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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
Author

Hi Alessandro,

Thanks very much! Worked perfectly!