7 Replies Latest reply: Jul 27, 2016 8:36 AM by Nina Iren Jensen RSS

    Master Calendar - Table not found

    Nina Iren Jensen

      Hi,

       

      I am new to Qlik Sense and using v3.0.

      I am trying to create a Master Calendar based on the video Creating A Master Calendar

       

      However I am getting some errors and I have tried to search for solutions, but so far I haven't been able to solve this.

      I get the following errormessage:

       

      Started loading data

      QuartersMap << AUTOGENERATE(12)

      Lines fetched: 12

       

      The following error occurred:

      Table not found

      The error occurred here:

      Temp:

      Load min(DateID) as minDate,

      max(DateID) as maxDate

      Resident Bagtall

       

      Data has not been loaded. Please correct the error and try loading again.

       

      DateID is my date field in the table (xlsx file with date format)

      The table were the date field is located is called Bagtall

       

      QuartersMap: 

      MAPPING LOAD  

      rowno() as Month, 

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

      AUTOGENERATE (12); 

           

      Temp: 

      Load 

      min(DateID) as minDate, 

      max(DateID) as maxDate 

      Resident Bagtall; 

           

      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 DateID, 

        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; 

       

      Hope someone is able to help me solve this