Variable in Load Script not being set

[Oggy172]

Hi all,

I've been continuing my Qlik journey, my actual training isnt until next week, but I've been making some progress.

I'm having an issue in that my variable isn't being set (Let) within the load script.

It is declared in the variable list (Edit Sheet, variables) as per the below.

However, when my load script runs, nothing is set to this variable.

Neither of the two Let statements work....

CalendarToday:
LOAD distinct FiscalWeek	as ThisWeek,
Sequence -1 as LastWeek
FROM [lib://QVD Data:Office_365_Sharepoint - a@b.com/Shared Documents/QlikSaaS/Calendar2.qvd]
(qvd) where Date=today();

let v_DefaultWk = Max('ThisWeek');
let v_DefaultWk = FieldValue('ThisWeek',1);

If I define the variable in the UI (outside of the load editor)

I've also tried the fully qualified fieldname 

let v_DefaultWk = Max('CalendarToday.ThisWeek');

[Oggy172 · Accepted solution]

The one syntax I didn't try worked!

let v_DefaultWk = FieldValue('CalendarToday.ThisWeek',1);