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

    All previous years compared to the selected year

    Marco Ponzo

      Hi,

      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?

      Thank's!


      Marco