15 Replies Latest reply: Apr 9, 2018 5:41 AM by Finbar Gillen RSS

    autoCalendar.YearMonth

    Finbar Gillen

      Hi,

       

      I am looking to use autoCalendar.YearMonth filter in an expression but it won't recognize 'Feb-2017'. It gives it in this format when i use it as a dimension in my charts.

       

      qlik.JPG

       

      Count(DISTINCT {<status={'Current'}, [RENDATE.autoCalendar.YearMonth] = {'Feb-2017'}>} ID) /

      Count(DISTINCT {<[RENDATE.autoCalendar.YearMonth] = {'Feb-2017'}>} ID)

       

      Anyone know the correct format?

       

      Regards

      Finbar