topic Re: How to show rows which have maximum date? in QlikView

topic Re: How to show rows which have maximum date? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882718#M997044 <HTML><HEAD></HEAD><BODY><P>may be I need to use below</P><P></P><P></P><P>=FirstSortedValue([Leave Date],-[Enter Date])</P></BODY></HTML> Tue, 23 Jun 2015 15:09:37 GMT 2015-06-23T15:09:37Z How to show rows which have maximum date? https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882716#M997042 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> I have input data in SQL table as below</P><P>                                                                                                                                                                            </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 556px;"><TBODY><TR><TD class="xl63" height="17" width="70">ID</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="50">EntryNo</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="62">Months</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="76">Sales</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="111">Enter Date</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="111">Leave Date</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="76">Total</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605491</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">150</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/08/2012</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/12/2012</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">750</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605492</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/01/2013</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/01/2013</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605493</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">10</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">150</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/02/2013</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/11/2013</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1500</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605494</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/12/2013</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/12/2013</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605495</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">150</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/01/2014</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/06/2014</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">900</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605496</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/07/2014</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/07/2014</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605497</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">150</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/08/2014</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/08/2014</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">150</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605498</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">8</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/09/2014</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/04/2015</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605499</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">160</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/05/2015</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/06/2016</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2240</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605500</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">8</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">150</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/07/2016</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/02/2017</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1200</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605501</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">10</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">252</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/03/2017</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/12/2017</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2520</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605502</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">262</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/01/2018</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/07/2018</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1834</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">605503</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">9</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">160</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/08/2018</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/04/2019</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1440</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">5354353</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">296080</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">782</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/10/2006</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/10/2006</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">782</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">5354353</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">296081</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">3</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">411</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/11/2006</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/01/2007</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1233</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">5354353</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">296082</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">9</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">362</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/02/2007</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/10/2007</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">3258</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">5354353</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">296083</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">34</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">484</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/11/2007</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/08/2010</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">16456</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">5354353</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">296084</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">12</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">250</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/09/2010</TD><TD align="right" class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/08/2011</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">3000</TD></TR></TBODY></TABLE><P></P><P></P><P>I need to show output data table in qvw as below</P><P>                     </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 257px;"><TBODY><TR><TD class="xl65" height="17" width="70">ID</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="76">Sales</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="111">Leave Date</TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">123242</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">160</TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26/04/2019</TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">5354353</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">250</TD><TD align="right" class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">25/08/2011</TD></TR></TBODY></TABLE><P>so, I need to show the rows only have max Leave Date for each ID</P><P></P><P>I have used below expression but it is not showing data and showing blank chart.</P><P></P><P>=FirstSortedValue([Leave Date],-ID)</P><P></P><P>Please can anyone suggest me how to do this.</P></BODY></HTML> Tue, 23 Jun 2015 15:01:07 GMT https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882716#M997042 2015-06-23T15:01:07Z Re: How to show rows which have maximum date? https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882717#M997043 <HTML><HEAD></HEAD><BODY><P>try</P><P>FirstSortedValue(Sales, -[Leave Date])</P></BODY></HTML> Tue, 23 Jun 2015 15:09:32 GMT https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882717#M997043 maxgro 2015-06-23T15:09:32Z Re: How to show rows which have maximum date? https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882718#M997044 <HTML><HEAD></HEAD><BODY><P>may be I need to use below</P><P></P><P></P><P>=FirstSortedValue([Leave Date],-[Enter Date])</P></BODY></HTML> Tue, 23 Jun 2015 15:09:37 GMT https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882718#M997044 2015-06-23T15:09:37Z Re: How to show rows which have maximum date? https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882719#M997046 <HTML><HEAD></HEAD><BODY><P>Thanks. This works for Sales. </P></BODY></HTML> Tue, 23 Jun 2015 15:11:47 GMT https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882719#M997046 2015-06-23T15:11:47Z Re: How to show rows which have maximum date? https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882720#M997047 <HTML><HEAD></HEAD><BODY><P>or this (you said by leave date)</P><P>FirstSortedValue([Leave Date], -[Leave Date])</P></BODY></HTML> Tue, 23 Jun 2015 15:12:11 GMT https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882720#M997047 maxgro 2015-06-23T15:12:11Z Re: How to show rows which have maximum date? https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882721#M997048 <HTML><HEAD></HEAD><BODY><P>Thanks. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 23 Jun 2015 15:13:26 GMT https://community.qlik.com/t5/QlikView/How-to-show-rows-which-have-maximum-date/m-p/882721#M997048 2015-06-23T15:13:26Z