5 Replies Latest reply: May 27, 2015 4:12 PM by Michael Tarallo RSS

    Qliksense Master Calender

    abhay singh

      hi all,

       

      i have Order Table

      Order

      OrderDate

      OrderId

      From... Path

       

      Temp:

      load   min(OrderID) as MinDate;

        max(OrderID) as MaxDate;

      Resident Order;

       

      let vMinDate = num(peek('MinDate',0,'Temp');

           vMaxDate= num(peek('MaxDate',0,'Temp');

       

      TempCalender:                                                                           /// Giving me error in Qliksense Field not found - <<=>: TempCalender: LOAD Date(+RecNo()-1)as TempDate AutoGenerate 1 while + IterNo()-1 <=  //  but working fine in qlikview

                     $(vMinDate) +Iterno()-1 as num,

                     Date($(vMinDate) +iterno()-1) as TempDate,

                     autogenerate 1 while $(vMinDate)  + iterno()-1 <= $(vMaxDate);

       

      Mastercalender:

       

      date(TempDate) as Date,

      Year(TempDate) as Year

       

      resident TempCalender;