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

    Qlik Sense - Bar Chart Question - Filter by Max Date

    Chris Douty

      Hello,

       

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

       

      Example:

      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?

       

      thanks,

      Chris