0 Replies Latest reply: Oct 31, 2016 10:22 AM by Chris Douty RSS

    Qlik Sense - Bar Chart Question - Filter by Max Date



      My database table is a salary history for employees, with a row for each salary change.



      Employee Number     Salary Change Date     Salary

      1                                   01/01/2001                    5

      1                                   01/01/2002                    10

      1                                   01/01/2003                    15


      I would like to create a bar chart that displays the following:


      Dimension: Employee Number

      Measure: Sum of the Salary for the most recent "Salary Change Date"


      Could someone point me in the right direction?