topic Qlik Sense - Bar Chart Question - Filter by Max Date in Visualization and Usability https://community.qlik.com/t5/Visualization-and-Usability/Qlik-Sense-Bar-Chart-Question-Filter-by-Max-Date/m-p/1201624#M74459 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>My database table is a salary history for employees, with a row for each salary change.</P><P></P><P><STRONG>Example:</STRONG></P><P>Employee Number&nbsp;&nbsp;&nbsp;&nbsp; Salary Change Date&nbsp;&nbsp;&nbsp;&nbsp; Salary</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P></P><P>I would like to create a bar chart that displays the following: </P><P></P><P>Dimension: Employee Number</P><P>Measure: Sum of the Salary for the most recent "Salary Change Date"</P><P></P><P>Could someone point me in the right direction?</P><P></P><P>thanks,</P><P>Chris</P></BODY></HTML> Mon, 31 Oct 2016 14:22:35 GMT 2016-10-31T14:22:35Z Qlik Sense - Bar Chart Question - Filter by Max Date https://community.qlik.com/t5/Visualization-and-Usability/Qlik-Sense-Bar-Chart-Question-Filter-by-Max-Date/m-p/1201624#M74459 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>My database table is a salary history for employees, with a row for each salary change.</P><P></P><P><STRONG>Example:</STRONG></P><P>Employee Number&nbsp;&nbsp;&nbsp;&nbsp; Salary Change Date&nbsp;&nbsp;&nbsp;&nbsp; Salary</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P></P><P>I would like to create a bar chart that displays the following: </P><P></P><P>Dimension: Employee Number</P><P>Measure: Sum of the Salary for the most recent "Salary Change Date"</P><P></P><P>Could someone point me in the right direction?</P><P></P><P>thanks,</P><P>Chris</P></BODY></HTML> Mon, 31 Oct 2016 14:22:35 GMT https://community.qlik.com/t5/Visualization-and-Usability/Qlik-Sense-Bar-Chart-Question-Filter-by-Max-Date/m-p/1201624#M74459 2016-10-31T14:22:35Z