4 Replies Latest reply: Nov 13, 2017 2:55 PM by Juan Moreno RSS

    Master Calendar with gaps in Qlik Sense

    Juan Moreno

      Hi all,


      I'm using the following drill-down master dimension in a dashboard:






      In the load script I defined start date like this:


      Date(Floor(start_timestamp)) AS start_date,


      I'm using a master calendar I took from another thread of the Qlik Community. The problem I'm having in charts is that using the drill-down master dimension, whenever a certain day doesn't have values, I get a gap in my axis representation. No matter that I check "Include null values".


      Do you think I may need to modify something in the master calendar?





        • Re: Master Calendar with gaps in Qlik Sense
          Juan Moreno

          This is my master calendar:



          MAPPING LOAD  

          rowno() as Month, 

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

          AUTOGENERATE (12); 




          min(start_date) as minDate, 

          max(start_date) as maxDate 

          Resident event; 


          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 start_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; 

          • Re: Master Calendar with gaps in Qlik Sense
            Juan Moreno

            After reading this thread "problem with master calendar and filtered data | Qlik Community" I've seen that the problem happens only when filtering. Apparently, it's the standard behavior in Qlik.