Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
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?
Try with this
let vamxdater =Date(peek('TransactionDate',0,'max'),'Your Date Format');
Try with this
let vamxdater =Date(peek('TransactionDate',0,'max'),'Your Date Format');
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?
How 0 is there in month
where TransactionDate>'04/?/2019'
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';