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 ??





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


      Thank you in advance!