topic How to display the latest date from a field with multiple dates in QlikView https://community.qlik.com/t5/QlikView/How-to-display-the-latest-date-from-a-field-with-multiple-dates/m-p/218252#M71417 <HTML><HEAD></HEAD><BODY><P>I have a date field which records every date when an application is updated. Every time the application is updated I want only the latest date to display in the Pivot table.</P><P>Please let me know if this is unclear as I am new to qlikview.</P><P>See screen shot<IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-887_sourceID:887" /></P><P></P></BODY></HTML> Wed, 20 Jan 2010 23:14:38 GMT 2010-01-20T23:14:38Z How to display the latest date from a field with multiple dates https://community.qlik.com/t5/QlikView/How-to-display-the-latest-date-from-a-field-with-multiple-dates/m-p/218252#M71417 <HTML><HEAD></HEAD><BODY><P>I have a date field which records every date when an application is updated. Every time the application is updated I want only the latest date to display in the Pivot table.</P><P>Please let me know if this is unclear as I am new to qlikview.</P><P>See screen shot<IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-887_sourceID:887" /></P><P></P></BODY></HTML> Wed, 20 Jan 2010 23:14:38 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-latest-date-from-a-field-with-multiple-dates/m-p/218252#M71417 2010-01-20T23:14:38Z How to display the latest date from a field with multiple dates https://community.qlik.com/t5/QlikView/How-to-display-the-latest-date-from-a-field-with-multiple-dates/m-p/218253#M71418 <HTML><HEAD></HEAD><BODY><P>Hi wvogt,</P><P>Use "max([Factory Actual Date])" as a new expression and delete the dimension [Factory Actual Date].</P><P>Regards Daan<B></B></P></BODY></HTML> Wed, 20 Jan 2010 23:30:15 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-latest-date-from-a-field-with-multiple-dates/m-p/218253#M71418 daan_koster 2010-01-20T23:30:15Z