topic incremental script problem in QlikView

incremental script problem

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

this is my script :-

max:
LOAD max (TransactionDate) as TransactionDate

FROM VWStockMovement_Qlik.qvd (qvd);

let vamxdater =Date(peek('TransactionDate',0,'max'));

drop table max;
final:
LOAD
NCode,
PartnerCode,
Channel,
ETPCode,
TransactionDate,
"Doc_Type",
TransactionNo,
Season,
Style,
Color,
Size,
TransactionQuantity,
ETPMRP;
SQL SELECT *
FROM ETPEASV55.dbo."VWStockMovement_Qlik" where TransactionDate>'$(vamxdater)';

Concatenate(final)
LOAD NCode,
PartnerCode,
Channel,
ETPCode,
TransactionDate,
Doc_Type,
TransactionNo,
Season,
Style,
Color,
Size,
TransactionQuantity,
ETPMRP
FROM
VWStockMovement_Qlik.qvd
(qvd);

i have used debugger also , please see my pics:-

i am getting this error , i have used double quotes also but its not working properly , any help?

Re: incremental script problem

prma7799 — Tue, 10 Sep 2019 05:13:13 GMT

Try with this

let vamxdater =Date(peek('TransactionDate',0,'max'),'Your Date Format');

Re: incremental script problem

riishabhz — Tue, 10 Sep 2019 05:30:07 GMT

i changed to

let vamxdater=Date(peek('SalesDate',0,'max'),'dd/mm/yyyy');

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Divide by zero error encountered.
SQL SELECT *
FROM ETPEASV55.dbo."VWStockMovement_Qlik" where TransactionDate>04/00/2019

what should i do now?

Re: incremental script problem

prma7799 — Tue, 10 Sep 2019 05:39:34 GMT

How 0 is there in month

where TransactionDate>'04/?/2019'

Re: incremental script problem

riishabhz — Tue, 10 Sep 2019 06:39:03 GMT

i changed my dateformat and timestamp into this and now its working

SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YY h:mm:ss[.fff] TT';