6 Replies Latest reply: Dec 4, 2017 8:15 AM by Manuel Tertre RSS

    Count Last Occurrence of Distinct ID

    Manuel Tertre

      I am trying to show a line chart or a bar chart representing the last time an user ID is present in the database.


      With the following table :

      ID, Date

      A, 2014

      B, 2014

      A, 2015

      C, 2015

      C, 2017

      C, 2017

      D, 2017

       

      I want the values of my chart to be 1 for 2014, 1 for 2015 and 2 for 2017.

       

      This thread Count Distinct Accumulation in Qlik Sense helped me a lot but I still don't know how to use the last occurrence instead of the first for a distinct count.