Master calendar in data load editor

[#1]

Hi!

I'm trying to follow the instructions to create master calendar (Understanding the Master Calendar - Qlik Sense and QlikView - YouTube), but when I go to Data Load editor, I don't have the same view (time 3:20 in the video). I have Main and then Auto-generated section which is locked. There's Unlock button, but it gives scary sounding ultimatum ("If you unlock the auto-generated script, you will not be able to edit the data selection with Data manager. Unlocking cannot be undone.")

Shall I unlock or create new section for adding new fields (Month, Year)? If I create new section, do I need to copy that whole load script or just add new fields?

BR Tiia

[kaushiknsolanki · Accepted solution]

Hi,

You can unlock the section. The warning says that you wont be able to use the data manager, but that should be ok.

It wont have any impact on script or the data.

Regards,

Kaushik Solanki

[#3]

Next problem. I used the following script. Program won't load the data. It says after 45 min that I'll need to fix something (didn't specify). Any suggestions where the problem could be?

QuartersMap: 

MAPPING LOAD  

rowno() as Month, 

'Q' & Ceil (rowno()/3) as Quarter 

AUTOGENERATE (12); 

Temp: 

Load 

min([Submit Date]) as minDate, 

max([Submit Date]) as maxDate 

Resident Basics; 

Let varMinDate = Num(Peek('minDate', 0, 'Temp')); 

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp')); 

DROP Table Temp; 

TempCalendar: 

LOAD 

$(varMinDate) + Iterno()-1 As Num, 

Date($(varMinDate) + IterNo() - 1) as TempDate 

AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate); 

MasterCalendar: 

Load 

  TempDate AS [Submit Date], 

  week(TempDate) As Week, 

  Year(TempDate) As Year, 

  Month(TempDate) As Month, 

  Day(TempDate) As Day, 

  ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter, 

  Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear, 

  WeekDay(TempDate) as WeekDay 

Resident TempCalendar 

Order By TempDate ASC; 

Drop Table TempCalendar;