2 Replies Latest reply: Jun 29, 2017 9:23 AM by Tiia Ojanaho RSS

    Master calendar in data load editor

    Tiia Ojanaho

      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

        • Re: Master calendar in data load editor
          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

          • Re: Master calendar in data load editor
            Tiia Ojanaho

            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;