topic Re: Modify Load statements with variables - syntax displays as error in QlikView

Modify Load statements with variables - syntax displays as error

Thu, 21 May 2015 07:58:55 GMT

Hi,

I try to use the same code for a full and a partial reload. Depending on which is executed, I want to add the 'add' keyword to the load statement with a variable:

if IsPartialReload() THEN

TRACE Executing partial reload;

Let vPartial = '1';

Let vAdd = 'add';

else

TRACE Executing full reload;

Let vPartial = '0';

Let vAdd ='';

endif;

....

concatenate (UM)

$(vAdd) LOAD * INLINE [

UserName, DeleteDate

LastUpdate, $(vDate)

];

This is working fine, but the script editor marks the whole concatenate stuff as syntax error. Disturbing. Is there a way to bypass this?

Thanks

Jens

Re: Modify Load statements with variables - syntax displays as error

Gysbert_Wassenaar — Thu, 21 May 2015 09:21:18 GMT

No, it's because the script editor can evaluate the $(vAdd). That only can be done at run time when the script is actually executed. Therefore the script editor can't know if you've unintentionally made an error or intentionally wrote down code that can't be determined to be correct.

Re: Modify Load statements with variables - syntax displays as error

Thu, 21 May 2015 09:27:55 GMT

Thanks, I was afraid that this is the answer. It's not really practical to have half the script highlighted as error.