1 Reply Latest reply: Apr 3, 2017 6:12 PM by Craig Sutton RSS

    Logic

    adarsh chaubey

      Greetings,

       

      I am new to qlikview pls help me understand following Logics...

       

       

      Load

      Date(TempDate) As Date,

      Year(YearStart(TempDate, 0, 4)) As FY,

      Dual(

      Text(Month(TempDate)),

      Num(Month(MonthStart(TempDate, -3)))

      ) As Period,

      Dual(

      Year(YearStart(TempDate, 0, 4)) & '-'

      & Num(Month(MonthStart(TempDate, -3)), '00'),

      MonthStart(TempDate)

      ) As FYPeriod,

      Year(TempDate) + Month(TempDate) + Day(TempDate) As Sales

      ;

      Load

      RecNo()-1+Floor(MakeDate(2012)) As TempDate