topic Re: How to use include files in qlikview in QlikView

How to use include files in qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

1) When do we use include files in qlikview?

2) What is the syntax for using includes in script

Syntax for both include and must include

3) what's the difference between include and must include. When to use what? Which one is prefered to be used?

Re: How to use include files in qlikview

florentina_doga — Fri, 10 Nov 2017 14:07:13 GMT

$(Include = filename )

The include variable specifies a file that contains text that should be included in the script. The entire script can thus be put in a file. A user-defined variable.

Example:

$(Include=abc.txt);

I.e. the construction set Include =filename is not applicable.

Re: How to use include files in qlikview

Anil_Babu_Samineni — Fri, 10 Nov 2017 14:11:03 GMT

Please start using community so you will get all basic stuff from help itself

Re: How to use include files in qlikview

oscar_ortiz — Fri, 10 Nov 2017 14:35:42 GMT

The idea behind include files is to give you the ability to share a bit of code within multiple QVW files.

The syntax is as florentina.dogaru‌ mentioned.

The difference between include and must include is that the include fails silently. What I mean by that is that if the file specified does not exists it will skip past that bit of code. The mus include will produce a hard fail if the file does not exist.

$(Include = filename )

$(Must_Include = filename )

Good luck!

Oscar

Re: How to use include files in qlikview

MK9885 — Fri, 10 Nov 2017 17:03:48 GMT

Below is the Include text I use in Qlik Data Load Editor....The red dots before \include is folder directory up or down (forward or back).

// DATABASE CONNECTION

LET vInclude_Filename = '..\Includes\DBConnection.txt';

LET vInclude_Directory = '..\Includes\Variables.txt';

TRACE <LOG> Attempting to INCLUDE file [$(vInclude_Filename)];

IF IsNull (FileTime( vInclude_Filename )) THEN;

TRACE File doesnt exist [ $(vInclude_Filename) ];

EXIT SCRIPT ;

END IF;

$(must_include=$(vInclude_Filename));

TRACE ('[$(vInclude_Filename) ] file was found and incorporated into script');

$(must_include=$(vInclude_Directory));

and you'd need to place the attached document in Include Folder or any other folder you like but then accordingly you'd have to modify the destination in include script..

Same kind of text document would got for Data Base Connection. Where you store your connection string(s).

And I agree with Anil, most of the answers to your questions are already available in community. Just search it and you'll get it.