topic Re: Problem with aggregation in QlikView https://community.qlik.com/t5/QlikView/Problem-with-aggregation/m-p/429311#M489267 <HTML><HEAD></HEAD><BODY><P>U can write script like this</P><P></P><P>if(TransDate=Aggr(max(Trans_Date), Lot_status),Lot_Status)</P><P></P><P>if u give sample data, than we can give correct expression..&nbsp; pls post sample</P></BODY></HTML> Wed, 12 Dec 2012 09:36:27 GMT 2012-12-12T09:36:27Z Problem with aggregation https://community.qlik.com/t5/QlikView/Problem-with-aggregation/m-p/429310#M489266 <HTML><HEAD></HEAD><BODY><P>Hey everyone, </P><P>im developing a new report about warehouse's. I have this little problem with an aggregation: </P><P></P><P>I have a Lot Status Field, this field may change in every line of the Lot Events Table. </P><P></P><P>The Lot Events Table has a transaction_date field with this format (dd/mm/yyyy hh.mm).</P><P></P><P>What i want to do is to take the lot status of the last transaction in the table lot events. </P><P></P><P>I tried Aggr(max(Trans_Date), Lot_status) but is returning -. </P><P></P><P>Ty for your time </P><P></P><P>Regards</P><P>Juan Pedro</P></BODY></HTML> Wed, 12 Dec 2012 09:15:31 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggregation/m-p/429310#M489266 2012-12-12T09:15:31Z Re: Problem with aggregation https://community.qlik.com/t5/QlikView/Problem-with-aggregation/m-p/429311#M489267 <HTML><HEAD></HEAD><BODY><P>U can write script like this</P><P></P><P>if(TransDate=Aggr(max(Trans_Date), Lot_status),Lot_Status)</P><P></P><P>if u give sample data, than we can give correct expression..&nbsp; pls post sample</P></BODY></HTML> Wed, 12 Dec 2012 09:36:27 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggregation/m-p/429311#M489267 2012-12-12T09:36:27Z Re: Problem with aggregation https://community.qlik.com/t5/QlikView/Problem-with-aggregation/m-p/429312#M489268 <HTML><HEAD></HEAD><BODY><P>Is working fine now thnks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Wed, 12 Dec 2012 10:03:33 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggregation/m-p/429312#M489268 2012-12-12T10:03:33Z