1 Reply Latest reply: Nov 22, 2017 2:35 AM by magnus lagerberg RSS

    Autocalendar in Sense 3.0

    Pascal THEUROT

      Unfortunately, it seems there's no improvement in Autocalendar feature in Qlik Sense 3.0.


      There's no way to have a year comparison using dual function as the value displayed is the year but the calculated value is a date (first day of the year). So, in demonstration there's no easy way to rapidly have that kind of comparison


      script generated :

      Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),


      works nice with this syntax :

        Year($1) AS [Year] Tagged ('$axis', '$year'),


      It would be nice too to choose the calendar language and if we need or not a calendar on each date fields.


      Of course, we can break the generated script... but not so friendly to use.


      But I've perhaps missed something ?