topic Find last price per ref in App Development https://community.qlik.com/t5/App-Development/Find-last-price-per-ref/m-p/17753#M1202 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm a qliksence beginer and i'm trying to find the last price value of each ref in my base.</P><P>The table is like</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">proref</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">price</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">03/03/18</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">03/03/17</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">04/10/16</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><P>01/01/18</P></TD><TD style="padding: 2px;">23</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">01/02/18</TD><TD style="padding: 2px;">24</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">10/12/17</TD><TD style="padding: 2px;">32</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">10/11/17</TD><TD style="padding: 2px;">23</TD></TR></TBODY></TABLE><P></P><P>I would like to find only (A,50) (B,24) and (C,32).</P><P>I'd tried some expression like firstsortedvalue(price,Aggr(min(date),proref)) and using aggregrate but it still not working.</P><P></P><P>I thinks I'm close to find but....<IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P>Does anyone can help me?</P><P></P><P>Thank you</P></BODY></HTML> Tue, 13 Mar 2018 10:02:15 GMT Anonymous 2018-03-13T10:02:15Z Find last price per ref https://community.qlik.com/t5/App-Development/Find-last-price-per-ref/m-p/17753#M1202 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm a qliksence beginer and i'm trying to find the last price value of each ref in my base.</P><P>The table is like</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">proref</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">price</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">03/03/18</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">03/03/17</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">04/10/16</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><P>01/01/18</P></TD><TD style="padding: 2px;">23</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">01/02/18</TD><TD style="padding: 2px;">24</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">10/12/17</TD><TD style="padding: 2px;">32</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">10/11/17</TD><TD style="padding: 2px;">23</TD></TR></TBODY></TABLE><P></P><P>I would like to find only (A,50) (B,24) and (C,32).</P><P>I'd tried some expression like firstsortedvalue(price,Aggr(min(date),proref)) and using aggregrate but it still not working.</P><P></P><P>I thinks I'm close to find but....<IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P>Does anyone can help me?</P><P></P><P>Thank you</P></BODY></HTML> Tue, 13 Mar 2018 10:02:15 GMT https://community.qlik.com/t5/App-Development/Find-last-price-per-ref/m-p/17753#M1202 Anonymous 2018-03-13T10:02:15Z Re: Find last price per ref https://community.qlik.com/t5/App-Development/Find-last-price-per-ref/m-p/17754#M1203 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Dimension</P><P>proref</P><P></P><P>Expression</P><P><STRONG>FirstSortedValue(price,&nbsp; -date)</STRONG></P></BODY></HTML> Tue, 13 Mar 2018 16:36:47 GMT https://community.qlik.com/t5/App-Development/Find-last-price-per-ref/m-p/17754#M1203 sunny_talwar 2018-03-13T16:36:47Z