Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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;