7 Replies Latest reply: Dec 11, 2017 2:37 AM by Marco Ponzo RSS

    All previous years compared to the selected year

    Marco Ponzo


      I'm Qlik beginner.


      I have a table with a column nominated DTASPR (hire date), with many dates (DD/MM/YYYY).


      I selected a Year (example 2007) to have a count of DTASPR (employee hired in that year):

      Count (DTASPR.autoCalendar.Year)

      and it's ok.


      This expression give me all the EXCLUDED DTASPR, for past and later years:

      Count ({1-$} [DTASPR.autoCalendar.Year])


      But I need the count of DTASPR only for PREVIOUS year (not later, example years<2007)

      I don't know how modifier or identifier use.

      Can you help me?