topic Re: must include is not working at qliksense in QlikView

must include is not working at qliksense

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

hi,

I have one folder connection in qliksense system:- 'EDI Vision Service Console' and I have created a 'Data Extractor' folder in that folder.

but when I include one script it gives me error of file not found:

$(Must_Include= lib://EDI Vision Service Console\Data Extractor\SUMMARISER_TRANSACTIONAL_FULL_LOAD.qvs);

Please help me.

What should I consider in the must include?

Message was edited by: sandip Ghosh

Re: must include is not working at qliksense

Anil_Babu_Samineni — Thu, 16 Nov 2017 08:56:39 GMT

Can you share the error image using Include

$(Include= lib://EDI Vision Service Console\Data Extractor\SUMMARISER_TRANSACTIONAL_FULL_LOAD.qvs);

Re: must include is not working at qliksense

HirisH_V7 — Thu, 16 Nov 2017 09:12:52 GMT

Hi,

If we you must_include means, it will throw an error if the file is not found.

In case you don't want to see any error means(may be no file is fetching by include), you can use Include in place of must_include.

-Hirish

Re: must include is not working at qliksense

ananyaghosh — Thu, 16 Nov 2017 11:32:30 GMT

hi,

I am using the below code:-

$(Must_Include= [lib://EDI Vision Service Console/Data Extractor\SUMMARISER_TRANSACTIONAL_FULL_LOAD.qvs]);

and it says that script not found. What to do now?

Re: must include is not working at qliksense

HirisH_V7 — Thu, 16 Nov 2017 12:00:11 GMT

Do check are u pointing the required Script file.

Re: must include is not working at qliksense

ananyaghosh — Thu, 16 Nov 2017 12:34:50 GMT

Here's what finally worked.

$(Include=[lib://FolderConnection\Subfolder under FolderConnection\Scripts\code.qvs]);

Re: must include is not working at qliksense

HirisH_V7 — Thu, 16 Nov 2017 12:42:41 GMT

oh good buddy. Please close thread.

Re: must include is not working at qliksense

trdandamudi — Thu, 16 Nov 2017 13:22:54 GMT

Just want to clarify here:

"Include" and "Must_Include" work exactly the same. The difference is, if the script file is missing in the path location then "Include" will not throw an error but "Must_Include" will give you an error.

So when you said "Finally it worked " the meaning is either the file is available in the path provided or it is not.

Hope this helps...

Re: must include is not working at qliksense

Anil_Babu_Samineni — Thu, 16 Nov 2017 13:28:29 GMT

Try like this?

SET Var = '$(Must_Include= [lib://EDI Vision Service Console/Data Extractor\SUMMARISER_TRANSACTIONAL_FULL_LOAD.qvs])';

Trace $(Var);

And show me the Reload script wizard elapsed time scrrenshot?