3 Replies Latest reply: Aug 30, 2017 1:45 PM by Sunny Talwar RSS

    Floor & Num Functions in Date output

    Luis Brum

      Hello Guys,

       

      I am new to Qliksense, and I would like to know the output of the following formulas for this value 20070209.

      Qliksense knows 20070209 is  a date and the monthstart function retrieves 20070201 ??

       

      FLOOR(NUM(MonthStart(DWH_Dim_ALL_Date_Day_ID)))                                                                                                                                     

      FLOOR(NUM(WeekStart(DWH_Dim_ALL_Date_Day_ID)))   

       

      I am not very sure of the role of NUM and FLOOR here.

       

      Thank you in advance!