https://community.qlik.com/t5/QlikView/Last-Price/m-p/155853#M31947 <HTML><HEAD></HEAD><BODY><P>Thanks! This is what I've been looking for. I have one addtiional complication, I have dates with blank unit prices. Is there anyway to aggregate this data only for dates with a valid unit price?</P></BODY></HTML> Thu, 10 Dec 2009 03:48:57 GMT 2009-12-10T03:48:57Z https://community.qlik.com/t5/QlikView/Last-Price/m-p/155851#M31945 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have asked this question before and was asked to provide an example. It dropped off the radar for a bit but is now back.</P><P>I am bringing in all the purchase receipts, what I want to be able to calculate is the last price paid to a supplier for a product at a site.</P><P>On the attached example I have created what I think should work using a calculated dimension. but this doesn't seem to work.</P><P></P><P>Any help much appreciated</P><P></P><P>Matt</P></BODY></HTML> Wed, 12 Aug 2009 18:56:42 GMT https://community.qlik.com/t5/QlikView/Last-Price/m-p/155851#M31945 2009-08-12T18:56:42Z https://community.qlik.com/t5/QlikView/Last-Price/m-p/155852#M31946 <HTML><HEAD></HEAD><BODY><P>You have to aggregate the calculate dimension to all dimensions which are used previous:</P><P style="font-weight: bold">=aggr(max("Date([Requested Receipt Date])"),site,supplierno,ItemNo)</P><P></P><P>Regards.</P></BODY></HTML> Wed, 12 Aug 2009 19:19:10 GMT https://community.qlik.com/t5/QlikView/Last-Price/m-p/155852#M31946 2009-08-12T19:19:10Z https://community.qlik.com/t5/QlikView/Last-Price/m-p/155853#M31947 <HTML><HEAD></HEAD><BODY><P>Thanks! This is what I've been looking for. I have one addtiional complication, I have dates with blank unit prices. Is there anyway to aggregate this data only for dates with a valid unit price?</P></BODY></HTML> Thu, 10 Dec 2009 03:48:57 GMT https://community.qlik.com/t5/QlikView/Last-Price/m-p/155853#M31947 2009-12-10T03:48:57Z https://community.qlik.com/t5/QlikView/Last-Price/m-p/155854#M31948 <HTML><HEAD></HEAD><BODY><P>Assuming anything non-null is a valid price, I think this:</P><P style="padding-left:30px;">=aggr(max(if(len("Price"),"Date([Requested Receipt Date])")),site,supplierno,ItemNo)</P></BODY></HTML> Thu, 10 Dec 2009 04:43:25 GMT https://community.qlik.com/t5/QlikView/Last-Price/m-p/155854#M31948 johnw 2009-12-10T04:43:25Z https://community.qlik.com/t5/QlikView/Last-Price/m-p/155855#M31949 <HTML><HEAD></HEAD><BODY><P>No luck so far. I've attached a file. Hopefully this helps. For some reason, this produces the same results.</P></BODY></HTML> Thu, 10 Dec 2009 05:26:43 GMT https://community.qlik.com/t5/QlikView/Last-Price/m-p/155855#M31949 2009-12-10T05:26:43Z