topic Re: Error : year field not found in Load script in QlikView

Error : year field not found in Load script

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

Hi all,

i am trying to execute/Load below code in script but it gives me 'year field not found' error

From below code i am trying to get previous year Weekend_Group_Year.

LOAD

date(WeekEnd(CanonicalDate), 'MM-DD-YY') as Weekend_Group_Year

RESIDENT DateBridge WHERE Date(CanonicalDate, 'YYYY') = $(= max(Year-1));

Why is this giving me this error, if year is a function

Please help me on this.

Chanty4u — Tue, 09 Aug 2016 12:02:11 GMT

what is ur date format?

Clever_Anjos — Tue, 09 Aug 2016 12:03:28 GMT

You should calculate first the max year

LOAD

Max(Year) as m

Resident yourtable;

LET M=Peek('m');

LOAD

date(WeekEnd(CanonicalDate), 'MM-DD-YY') as Weekend_Group_Year

RESIDENT DateBridge WHERE Date(CanonicalDate, 'YYYY') = $(M);

Anonymous — Tue, 09 Aug 2016 12:04:37 GMT

has the field 'Year' found in the table DateBridge ?

otherwise you have to try like this ..

LOAD

date(WeekEnd(CanonicalDate), 'MM-DD-YY') as Weekend_Group_Year

RESIDENT DateBridge

WHERE Date(CanonicalDate, 'YYYY') = $(= max(Year((CanonicalDate))-1));

berryandcherry6 — Tue, 09 Aug 2016 12:21:11 GMT

hi,

Yes year is found in datebridge