8 Replies Latest reply: May 13, 2014 5:32 PM by Matteo Minischetti RSS

    Missing dates in MasterCalendar due to left join

      Hello,

       

      I have made a left join and hereby i have noticed that i am missing the last dates i have (so my month stops too early)

       

      My Date_Clean has all the dates but my month is missing on the lates dates, so in this example i wont get Month on May (And i have Date_Clean fields from May)

       

      How come?

       

      Sales:

      Load

      EntryID,

          Upper(CustomerID) as CustomerID,

          DATE#(DATE(CreateDate,'YYYY-MM-DD')) as Date_Clean, //Create DateKey to TimeDimension

          num(DATE#(DATE(CreateDate,'YYYY-MM-DD'))) as Date_CleanNumeric,

          Time(Floor(Frac(CreateDate),1/24/60),'hh:mm') as Time,

          Time(Floor(Frac(CreateDate),1/24/60),'hh:mm') as Time2, //Create HourKey To TimeDimension

          CreateDate,

          SessionIDINT,

          CookieIDINT,CookieIDINT as TempActiveUsersCookies,

          ItemName,

          Price,ItemID,CustomerGUID,ApiMethod,

       

          SessionUserFeatureINT,

          Capitalize(EventType) as EventType, //Make all events start with a BIG letter first

         

          Resident Hej

          Order by CreateDate;

       

        Left join

       

        TempActiveCookiesUsers:

        LOAD TempActiveUsersCookies,EventType, NumberOfBuys,GroupingBuyers

       

      from D:\QlikviewLoad\QVD\TempActiveUsersCookies.qvd

      (qvd);