topic Re: Include Statement - Include Tab?! in QlikView

Include Statement - Include Tab?!

dinicholls — Fri, 06 Feb 2015 14:41:49 GMT

Hi All,

I've just come across a bit of info about the 'Include Statement', and it looks like it would be really useful for me.

I just have one question though. The example I've found states to go to the 'Include' tab in the script editor. What, and where can I find the include tab, or can add my statement anywhere?

I know I can go through the Insert / Include Statement from the menu to insert it, but I just want to make sure its going in the right place!

Thanks!

Re: Include Statement - Include Tab?!

Gysbert_Wassenaar — Fri, 06 Feb 2015 14:44:52 GMT

There is no Include tab. Unless you first add a tab and named it Include. You could then use it to put all the include statements on.

Re: Include Statement - Include Tab?!

giakoum — Fri, 06 Feb 2015 14:45:12 GMT

Hi Diane

you can add your statements in a text file (I usually use a qvs file) and then include this into your application's reload script.

Very useful for repeating code.

Re: Include Statement - Include Tab?!

marcus_sommer — Fri, 06 Feb 2015 14:54:17 GMT

If your include-variable not contained a sub-routine which will be executed per call-statement (in this case you could create a script-tab for these include-variables) need the include-variable exactly there placed where these script-statements would be written out. What is more sensible depends on many things but you should only outsource code which is shared between multiple apps.

- Marcus

Re: Include Statement - Include Tab?!

datanibbler — Fri, 06 Feb 2015 15:01:31 GMT

Hi,

INCLUDEs are really practical. I use them a lot already and I'm constantly adding more:

All the file_paths to Excel_files I use are organized in INCLUDE_files (a normal txt_file will do);

The paths to where some apps store qvd_files are in INCLUDE_files (and of course, the apps which load those qvd_files use those same INCLUDE_files to find the paths to those qvd_files);

The complete code that creates the master_calendar for all my apps is in an INCLUDE_file;

Some "default" blocks of code that should be in every app (like a code that empties an app of data when it's copied to the backup_directory and a code to create the visibility_condition for some development_objects) are also in INCLUDE_files.

Best regards,

DataNibbler

Re: Include Statement - Include Tab?!

Peter_Cammaert — Fri, 06 Feb 2015 16:26:27 GMT

Watch out with the term "Include Statement". QlikView script has a construct that allows you to import text from another file, but it is certainly not a statement. And the difference is apparent if you try to comment out the construct.

A statement can easily be commented out by putting two slashes at the beginning of the line. You cannot do that with an include construct because in reality it's just a $-substitution that works in any line that the scirpt engine tries to read and before the engine decides what it is looking at.. What is happening with

// $(include=procedure.qvs);

is that the $(include ) construct will be replaced with the contents of file procedure.qvs, and the first line of that file will be commented out. Which is probably not what you want.

If you need to disable an include, replace the $-sign with two slashes and you're good.

Re: Include Statement - Include Tab?!

engishfaque — Fri, 06 Feb 2015 18:27:33 GMT

Dear Diane,

Include statement is very useful.

You are going in right direction to insert include statement.

Edit Script > Tab Insert > Include Statement > Browse/Open your file.

This type of syntax/statement will appeared in your script editor $(Include=YourFileName.YourFileExtension);

Example:

$(Include=myrowscount.qvs);

After that, just reload your script (CTRL+R).

Kind regards,

Ishfaque Ahmed

Re: Include Statement - Include Tab?!

rwunderlich — Fri, 06 Feb 2015 18:31:32 GMT

Also be aware of Must_Include.

$(Must_Include=myrowscount.qvs)

Include fails silently. That is, there is no script error if the included file is not found. Must_Include throws a script error if the file is not found. I generally use Must_Include.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Include Statement - Include Tab?!

qlikviewwizard — Fri, 14 Aug 2015 02:59:03 GMT

Hi DiNicholls

Please close the thread if you get the answer. Thank you.