https://community.qlik.com/t5/QlikView/Select-only-the-last-value-from-a-table/m-p/442944#M489574 <HTML><HEAD></HEAD><BODY><P>I have two tables joined...a sales table and the transaction table.&nbsp; The sales table lists the items that were sold for the previous month, and the transaction table which lists purchasing records for the past year.&nbsp; When I join the tables by the the item number, I get back all the purchasing transactions for that item.&nbsp; I would like to limit the result to the last purchasing transaction by date (i.e. the most recent purchasing transaction).&nbsp; I am not sure if this is a set analysis problem or something else.</P><P></P><P>Thank you in advance for your assistance.</P><P></P><P>Jerry Horton</P></BODY></HTML> Sat, 17 Nov 2012 12:02:40 GMT 2012-11-17T12:02:40Z https://community.qlik.com/t5/QlikView/Select-only-the-last-value-from-a-table/m-p/442944#M489574 <HTML><HEAD></HEAD><BODY><P>I have two tables joined...a sales table and the transaction table.&nbsp; The sales table lists the items that were sold for the previous month, and the transaction table which lists purchasing records for the past year.&nbsp; When I join the tables by the the item number, I get back all the purchasing transactions for that item.&nbsp; I would like to limit the result to the last purchasing transaction by date (i.e. the most recent purchasing transaction).&nbsp; I am not sure if this is a set analysis problem or something else.</P><P></P><P>Thank you in advance for your assistance.</P><P></P><P>Jerry Horton</P></BODY></HTML> Sat, 17 Nov 2012 12:02:40 GMT https://community.qlik.com/t5/QlikView/Select-only-the-last-value-from-a-table/m-p/442944#M489574 2012-11-17T12:02:40Z