4 Replies Latest reply: Mar 29, 2017 7:19 AM by Sunny Talwar RSS

    Qlik Sense: Displaying data with the maximum date

    Yassine Bechqito

      I need to create a filter on a Qlik Sense dashboard to return the latest result from a table. Let's say I have the follwoing table:

       

      NameSubjectScoreDate
      JohnMathematics21.1.2017
      MarcMathematics51.1.2017
      JohnMathematics315.2.2017
      PeterMathematics115.2.2017
      JohnMathematics47.3.2017

       

       

      In this example, John is displayed 3 times for the same subject. How can I make a filter to display only his latest results? i.e. the one on 7.3.2017?

       

      The actual table has hundreds of records, so ideally the filter will display only the latest results for the users having multiple records with similar names and subjects.