topic Re: script;How can I get only the last transaction in QlikView https://community.qlik.com/t5/QlikView/script-How-can-I-get-only-the-last-transaction/m-p/271670#M708681 <HTML><HEAD></HEAD><BODY><P>Try if u like this.</P><P></P><P>C u,</P><P>Stefano.</P></BODY></HTML> Mon, 19 Sep 2011 10:09:47 GMT 2011-09-19T10:09:47Z script;How can I get only the last transaction https://community.qlik.com/t5/QlikView/script-How-can-I-get-only-the-last-transaction/m-p/271668#M708679 <HTML><HEAD></HEAD><BODY><P>Dear QV-Users,</P><P></P><P>I have 2 tabels. One with the transactions in a period and the ohter table is a MASTER FILE with the StockNo. I would like to write a script that will show me only the last transaction date for each StockNo. My tabels are:</P><P></P><P>Transactions:</P><UL><LI>StockNo</LI><LI>ReceivingDate&nbsp; (format is YYYYMMDD; for today it will be "20110919")</LI><LI>Account</LI><LI>AccountCr</LI></UL><P></P><P></P><P>MasterFileStock:</P><UL><LI>StockNo</LI><LI>UnitCost</LI><LI>QuantityOnHand</LI></UL><P></P><P></P><P>Could someone tell me what the best approach will be for this case?</P><P></P><P>Regards,</P><P></P><P>Aissam</P></BODY></HTML> Mon, 19 Sep 2011 10:00:14 GMT https://community.qlik.com/t5/QlikView/script-How-can-I-get-only-the-last-transaction/m-p/271668#M708679 2011-09-19T10:00:14Z script;How can I get only the last transaction https://community.qlik.com/t5/QlikView/script-How-can-I-get-only-the-last-transaction/m-p/271669#M708680 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>u can calculate the max reciving date from the first table then filter the second tabel with a left join with the first..</P><P></P><P>I hope to be clear.</P><P></P><P>C u,</P><P>Stefano.</P></BODY></HTML> Mon, 19 Sep 2011 10:04:27 GMT https://community.qlik.com/t5/QlikView/script-How-can-I-get-only-the-last-transaction/m-p/271669#M708680 2011-09-19T10:04:27Z Re: script;How can I get only the last transaction https://community.qlik.com/t5/QlikView/script-How-can-I-get-only-the-last-transaction/m-p/271670#M708681 <HTML><HEAD></HEAD><BODY><P>Try if u like this.</P><P></P><P>C u,</P><P>Stefano.</P></BODY></HTML> Mon, 19 Sep 2011 10:09:47 GMT https://community.qlik.com/t5/QlikView/script-How-can-I-get-only-the-last-transaction/m-p/271670#M708681 2011-09-19T10:09:47Z