topic unknown statement WHERE LastModifiedDate >=$(vLastExecTime) and LastModifiedDate < $(vSFDCExecTime);// and IsDeleted = false; in QlikView

unknown statement WHERE LastModifiedDate >=$(vLastExecTime) and LastModifiedDate < $(vSFDCExecTime);// and IsDeleted = false;

Mon, 26 Jan 2026 16:26:21 GMT

The following statement had no problem on my system,

WHERE LastModifiedDate >=$(vLastExecTime) and LastModifiedDate < $(vSFDCExecTime);

but when i run it on different system ,the error is

unknown statement

WHERE LastModifiedDate >=$(vLastExecTime) and LastModifiedDate < $(vSFDCExecTime);

Anonymous — Mon, 07 Oct 2013 13:49:30 GMT

In any case, use single quotes:

WHERE LastModifiedDate >='$(vLastExecTime)' and LastModifiedDate < '$(vSFDCExecTime)';

And - what is the difference between the systems?

Mon, 07 Oct 2013 14:02:53 GMT

Hi,

vLatExecTime is the variable then check the variable declaration while running in other system

Mon, 04 Nov 2013 07:19:20 GMT

The error

Unknown statement

WHERE Not(Exists (Id))

due to

LOAD *

FROM $(vIntegratedQVDPath)SFDC_$(tableName).qvd (qvd); // due to semi colon here which ends the statement

WHERE Not(Exists (Id));