Variable in Load Script not being set

Oggy172 — Wed, 13 Nov 2024 10:58:31 GMT

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');

Re: Variable in Load Script not being set

Oggy172 — Wed, 13 Nov 2024 11:12:09 GMT

The one syntax I didn't try worked!

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

topic Variable in Load Script not being set in Connectivity & Data Prep

Variable in Load Script not being set

Re: Variable in Load Script not being set