Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is include and Must_Include in qlikview and difference

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.

8 Replies
maxgro
MVP
MVP

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);

satishkurra
Specialist II
Specialist II

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

Not applicable
Author

Thanks Satish

Not applicable
Author

Thanks Massimo Grossi

marcus_sommer

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

Not applicable
Author

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

Gabriel
Partner - Specialist III
Partner - Specialist III

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