topic Re: Last Price Paid in QlikView https://community.qlik.com/t5/QlikView/Last-Price-Paid/m-p/386831#M1152657 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use </P><P></P><P>FirstSortedValue(Price,-date)</P><P></P><P>Hope it helps</P></BODY></HTML> Mon, 22 Apr 2013 22:36:10 GMT MayilVahanan 2013-04-22T22:36:10Z Last Price Paid https://community.qlik.com/t5/QlikView/Last-Price-Paid/m-p/386829#M1152653 <HTML><HEAD></HEAD><BODY><P>I have a list of Material numbers along with the prices that we paid for them over a full year with dates.&nbsp; The prices are not always the same.&nbsp; However, I am creating a Pivot table in quikview that will show me the latest price paid.&nbsp; Any idea how to write that in the Expression field?</P></BODY></HTML> Mon, 22 Apr 2013 21:18:47 GMT https://community.qlik.com/t5/QlikView/Last-Price-Paid/m-p/386829#M1152653 2013-04-22T21:18:47Z Re: Last Price Paid https://community.qlik.com/t5/QlikView/Last-Price-Paid/m-p/386830#M1152655 <HTML><HEAD></HEAD><BODY><P>Firstsortedvalue(Price, -Date)</P></BODY></HTML> Mon, 22 Apr 2013 22:32:16 GMT https://community.qlik.com/t5/QlikView/Last-Price-Paid/m-p/386830#M1152655 danielrozental 2013-04-22T22:32:16Z Re: Last Price Paid https://community.qlik.com/t5/QlikView/Last-Price-Paid/m-p/386831#M1152657 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use </P><P></P><P>FirstSortedValue(Price,-date)</P><P></P><P>Hope it helps</P></BODY></HTML> Mon, 22 Apr 2013 22:36:10 GMT https://community.qlik.com/t5/QlikView/Last-Price-Paid/m-p/386831#M1152657 MayilVahanan 2013-04-22T22:36:10Z Re: Last Price Paid https://community.qlik.com/t5/QlikView/Last-Price-Paid/m-p/386832#M1152659 <HTML><HEAD></HEAD><BODY><P>The Following will work</P><P></P><P>=FIRSTSORTEDVALUE(Price,-Date)</P><P></P><P>the below will work to find out the Date where the Price is at it's highest</P><P></P><P>=DATE(FIRSTSORTEDVALUE(Date,-Price))</P><P></P><P>hope that helps</P><P></P><P>Regards</P><P></P><P>Alan</P></BODY></HTML> Mon, 22 Apr 2013 22:50:31 GMT https://community.qlik.com/t5/QlikView/Last-Price-Paid/m-p/386832#M1152659 rustyfishbones 2013-04-22T22:50:31Z