topic Re: max date in QlikView https://community.qlik.com/t5/QlikView/max-date/m-p/959539#M329411 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=FirstSortedValue(Qty, -Date)</P></BODY></HTML> Sat, 19 Dec 2015 13:07:36 GMT swuehl 2015-12-19T13:07:36Z max date https://community.qlik.com/t5/QlikView/max-date/m-p/959538#M329410 <HTML><HEAD></HEAD><BODY><P>I want to show the last sold quantity (for max(Date) per product) in a pivot table. It works for one single product, but not for all products. Anyone has an idea?</P></BODY></HTML> Sat, 19 Dec 2015 08:03:00 GMT https://community.qlik.com/t5/QlikView/max-date/m-p/959538#M329410 p_noindl 2015-12-19T08:03:00Z Re: max date https://community.qlik.com/t5/QlikView/max-date/m-p/959539#M329411 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=FirstSortedValue(Qty, -Date)</P></BODY></HTML> Sat, 19 Dec 2015 13:07:36 GMT https://community.qlik.com/t5/QlikView/max-date/m-p/959539#M329411 swuehl 2015-12-19T13:07:36Z Re: max date https://community.qlik.com/t5/QlikView/max-date/m-p/959540#M329412 <HTML><HEAD></HEAD><BODY><P>Is this?</P><P><IMG alt="p64.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109477_p64.png" style="height: 397px; width: 620px;" /></P></BODY></HTML> Sat, 19 Dec 2015 15:51:17 GMT https://community.qlik.com/t5/QlikView/max-date/m-p/959540#M329412 ecolomer 2015-12-19T15:51:17Z Re: max date https://community.qlik.com/t5/QlikView/max-date/m-p/959541#M329413 <HTML><HEAD></HEAD><BODY><P>Many thanks, I have forgotten that firstsortedvalue can have a - argument.</P></BODY></HTML> Sat, 19 Dec 2015 18:07:20 GMT https://community.qlik.com/t5/QlikView/max-date/m-p/959541#M329413 p_noindl 2015-12-19T18:07:20Z