6 Replies Latest reply: Apr 17, 2016 5:17 AM by Bruno Preti RSS

    Qlik Sense 2.2 automatic date handling - set analysis

    Roland Vecera

      Hi!

       

      I'm just testing the Qlik Sense 2.2 automatic date handling.

      From what I see it generates the script statement:  DECLARE FIELD DEFINITION Tagged ('$date')

       

      The last thing I remember about "DECLARE" is, that it has a strange behavior with SET ANALYSIS.

      From my tests SET ANALYSIS with Inline Variables I still see a strange behavior in QlikSense 2.2:

       

      To calculate the previous year instead of

       

      Sum({<MyDate.autoCalendar.Year={$(=max(MyDate.autoCalendar.Year)-1))}>}quantity)

       

      I had to use

       

      Sum({<MyDate.autoCalendar.Year={$(=year(max(MyDate.autoCalendar.Year))-1)}>}quantity)

       

      See below a sample application; Without the year-function, the variable-expression returns a date, even I interact with the year-field in Set Analysis.

       

      I just want to double check if this is working as designed, or is this a matter of change in future Qlik Sense releases. If so, I would have to wait before we implement this feature at customers.

       

      Thx,

      Roland

       

      NordwindTest - Mein neues Arbeitsblatt  Arbeitsblätter - Qlik Sense - Mozilla F__2016-03-01_14-14-15.png