topic Re: What is include and Must_Include in qlikview and difference in QlikView

What is include and Must_Include in qlikview and difference

Fri, 20 Nov 2020 18:02:30 GMT

Hi friends,

This is ramesh. I am totally consufed in those, can you please explain the simple manner with small examples.i am new to to qlikview.

i con't do any thing without support Qlikview community.Please help me.

Thanks&Regards

Ramesh.

Re: What is include and Must_Include in qlikview and difference

maxgro — Sun, 05 Oct 2014 13:59:42 GMT

From Qlikview online help, difference in bold

$(Include =filename )

$(Must_Include =filename )

The include and must_include variables specify a file that contains text that should be included in the script. The entire script can thus be put in a file. This is a a user-defined variable.

The difference between include and must_include is that include will fail silently if the file is not found during script reload, while must_include will throw an error if the file is not found.

Examples:

$(Include=abc.txt);

$(Must_Include=def.txt);

Re: What is include and Must_Include in qlikview and difference

fkeuroglian — Sun, 05 Oct 2014 18:45:28 GMT

Hope helps!

Fernando

Include and MustInclude

http://www.quickintelligence.co.uk/qlikview-include-files/

Re: What is include and Must_Include in qlikview and difference

satishkurra — Mon, 06 Oct 2014 03:44:08 GMT

Include and Must Include statements behave in the same way and the output is also same.

The difference you see is when there is any discrepancy in the file path or file name, Include statement will go blind and doesn't intimate anything to the developer whereas must include throws script error if there is any to the developer

Re: What is include and Must_Include in qlikview and difference

Wed, 08 Oct 2014 10:59:14 GMT

Thanks Satish

Re: What is include and Must_Include in qlikview and difference

Wed, 08 Oct 2014 10:59:53 GMT

Thanks Massimo Grossi

Re: What is include and Must_Include in qlikview and difference

marcus_sommer — Tue, 11 Nov 2014 15:26:55 GMT

I have experienced another difference between include and must_include to the effect that must_include ignored an previous exit script statement - it will be executed.

Are there further undocumented and annoying features?

- Marcus

Re: What is include and Must_Include in qlikview and difference

Tue, 11 Nov 2014 15:31:49 GMT

Hi,

Examples:

$(Include=sample.txt);

if it doesn't find the file also it won't throw the error msg while loading.

but

$(Must_Include=sample1.txt); if it doesn't find the file then it will throw the error msg while loading the script.

Must_include means must it has the file in that file location

Re: What is include and Must_Include in qlikview and difference

Gabriel — Tue, 11 Nov 2014 17:37:39 GMT

Hi,

With $(Must_Include=Test.txt); if Test.txt is not found qlikview shows you error msg and you immediately know that Test.txt doesn't exist or file name has change and start debugging.

With $(Include=Test.txt); qlikview will not give you error msg which doesn't help. The script will load and you will expect whatever is in Test.txt to be included in your file.

I will advice to always use MUST_INCLUDE.

Hope this helps

Best Regards,

Gabriel