Script error with latest extract date

ashmitp869 — Mon, 03 May 2021 06:07:57 GMT

Hi there ,

I am getting an error in qlikview script like below image -

My qlikview script :

SQL
SELECT
CAST(max([StartDateTime]) AS DATE) AS LATEST_EXTRACT
FROM "TEST".dbo.[view_test]
where [Id] in ('aaa','vv','cc');

LET vExtractDate = Num(Peek('LATEST_EXTRACT', 0, 'EXTRACT_DATE'));

SQL SELECT *
FROM "TEST".dbo.[view_test]
where [Id] in ('aaa','vv','cc')
and DATEFROMPARTS(YEAR([StartDateTime]), MONTH([StartDateTime]),DAY([StartDateTime]))>=DATE($(vExtractDate) - 366)

the requiement is to load the data greater than the LATEST_EXTRACT date.

Regards

Re: Script error with latest extract date

MayilVahanan — Mon, 03 May 2021 08:47:14 GMT

Hi @ashmitp869

In SQL, there is no built function like "Date". You need to use DateAdd() function, like below

DATEFROMPARTS(YEAR([StartDateTime]), MONTH([StartDateTime]),DAY([StartDateTime]))>=

Cast(DATEAdd(Day, -366,$(vExtractDate)) as Date);

topic Script error with latest extract date in QlikView

Script error with latest extract date

Re: Script error with latest extract date