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

    Master Calendar - Table not found

    Nina Iren Jensen



      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:


      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




      rowno() as Month, 

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

      AUTOGENERATE (12); 




      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; 




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

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

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




        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