2 Replies Latest reply: Apr 28, 2015 11:22 AM by Michael Tarallo RSS

    Qlik Sense - Date & Time

      I'm trying to use the new date & time feature in QS 1.1.0.

       

      Issue 1: The Load is failing & I'm getting a script line error. What am I doing wrong ? Here's what I am using

       

      Calendar:

      Declare Field Definition Tagged '$Date'

        Parameters

          first_month_of_year = 1

          Fields

              Year($1) as Year Tagged '$year',

              Month($1) as Month Tagged '$month',

              Date($1) as Date Tagged ('$date', '$day'),

              Week($1) as Week Tagged '$week'

          Groups

              Year, Month, Date type Collection as YearMonthDate;

       

      Issue 2: Is there an equivalent for Quarter ?

       

      Thanks. Rahul

        • Re: Qlik Sense - Date & Time
          Gysbert Wassenaar

          Try 'Q' & ceil*(Month($1)/3) as Quarter Tagged '$quarter'


          Don't forget to add a DERIVE statement after defining the fields. See the help for details:

          http://help.qlik.com/sense/en-US/online/#../Subsystems/Hub/Content/Scripting/DerivedFields.htm

          • Re: Qlik Sense - Date & Time
            Michael Tarallo

            Hi Rahul,

             

            Please see my replies in this thread for more information:

             

            Re: Derived calendar groups doesn't show up

             

            In regards to the "Groups" syntax - that is reserved for a future feature - where it has been implemented in the back-end, but not yet exposed in the UI. There was a mistake adding that in the sample code in the documentation, and it is being updated. The Groups feature will be available in a  future release - where it will automatically create the collection and cyclic groups for those specified fields.

             

            Calendar:

            DECLARE FIELD DEFINITION TAGGED '$date'

               Parameters

                  first_month_of_year = 1

               Fields

                  Year($1) As Year Tagged '$year',

                  Month($1) as Month Tagged '$month',

                  MonthName($1) as MonthName Tagged '$monthname',

                  Date($1) as Date Tagged ('$date', '$day'),

                  Week($1) as Week Tagged '$week',

               WeekName($1) as WeekName Tagged '$weekname',     

                  Weekday($1) as Weekday Tagged '$weekday',

                  DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear,

               'Q' & ceil*(Month($1)/3) as Quarter Tagged '$quarter'

             

            DERIVE FIELDS FROM FIELDS "Claim Creation Date" USING Calendar;

             

             

            Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

             

            Regards,

            Mike Tarallo

            Qlik