Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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?



Tags (3)