topic Re: Is it possible to call an Include file within a Sub Routine in QlikView

Is it possible to call an Include file within a Sub Routine

rustyfishbones — Wed, 17 Apr 2019 15:57:17 GMT

Hi,

Is it possible to call an include file within a Sub Routine like below example, which doesn't work?

SUB plt.Global(_Cust)

LET _Cust = IF(LEN('$(_Cust)') = 0 , 'EXIT SCRIPT;', '$(Must_Include=c:\qlikview\customers\$(_Cust)\bin\global.qvs)');

END SUB

CALL plt.Global('MyCustomer');

Re: Is it possible to call an Include file within a Sub Routine

albertovarela — Wed, 17 Apr 2019 16:33:12 GMT

Try:

Sub plt.Global(_Cust)

If Len($(_Cust)) = 0 THEN
Exit SCRIPT;
ELSE
$(Must_Include=c:\qlikview\customers\$(_Cust)\bin\global.qvs);
ENDIF

END Sub

CALL plt.Global('MyCustomer');

Re: Is it possible to call an Include file within a Sub Routine

rustyfishbones — Wed, 17 Apr 2019 19:19:45 GMT

Thanks, I will try tomorrow morning when I get back to it, thanks

Re: Is it possible to call an Include file within a Sub Routine

rustyfishbones — Thu, 18 Apr 2019 07:58:11 GMT

Thanks,

The "Must" throws an error as the Variable is not defined within the Sub Routine, so removing the Must part in the include statement allows the routine to run, the other issue is that if the global.qvs file does not exist, it will also not throw an error, but at least it works somewhat.

So the below works perfect

Sub plt.Global(_Cust)

If Len('$(_Cust)') = 0 THEN
Exit SCRIPT;
ELSE
$(Include=c:\qlikview\customers\$(_Cust)\bin\global.qvs);
ENDIF

END Sub

CALL plt.Global('MyCustomer');

Re: Is it possible to call an Include file within a Sub Routine

albertovarela — Thu, 18 Apr 2019 15:25:04 GMT

I'm glad you made it work.