topic Re: How to get values correspoding to latest date? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896868#M1011499 <HTML><HEAD></HEAD><BODY><P>use max(lastdate)</P></BODY></HTML> Thu, 07 May 2015 14:30:24 GMT 2015-05-07T14:30:24Z How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896862#M1011491 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data in source table as below</P><P></P><P>sample data for eg:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="645"><TBODY><TR><TD class="xl65" height="17" width="99">Form</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="83">ID</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="117">LastDate</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="137">NoEntries</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="94">Sum</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="115">Old</TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">HYT</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;">9054526</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;">18/06/2007<BR />&nbsp; 00:00</TD><TD align="right" class="xl68" 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 align="right" class="xl68" 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;">988</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;">02/11/2013<BR />&nbsp; 00:00</TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">HYT</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;">9054527</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;">18/04/2012<BR />&nbsp; 00:00</TD><TD align="right" class="xl68" 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;">58</TD><TD align="right" class="xl68" 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;">494</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;">02/11/2013<BR />&nbsp; 00:00</TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">HYT</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;">9054528</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;">18/05/2012<BR />&nbsp; 00:00</TD><TD align="right" class="xl68" 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 align="right" class="xl68" 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="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;">02/11/2013<BR />&nbsp; 00:00</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>I need to show output in qvw as below</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 645px;"><TBODY><TR><TD class="xl65" height="17" width="99">Form</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="83">ID</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="117">LastDate</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="137">NoEntries</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="94">Sum</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="115">Old</TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">HYT</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;">9054528</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;">18/05/2012<BR />&nbsp; 00:00</TD><TD align="right" class="xl68" 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 align="right" class="xl68" 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="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;">02/11/2013<BR />&nbsp; 00:00</TD></TR></TBODY></TABLE><P></P><P>so, I need to show the rows which have latest&nbsp; 'LastDate'</P><P></P><P>Please can anyone suggest me how to do this.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 07 May 2015 13:56:29 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896862#M1011491 2015-05-07T13:56:29Z Re: How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896863#M1011492 <HTML><HEAD></HEAD><BODY><P>If the LastDate field has no duplicate values, you may use the following expressions:</P><P>FirstSortedValue(ID,-LastDate)</P><P>FirstSortedValue(LastDate,-LastDate)</P><P>FirstSortedValue(NoEntries,-LastDate)</P><P>FirstSortedValue(Sum,-LastDate)</P><P>FirstSortedValue(Old,-LastDate)</P></BODY></HTML> Thu, 07 May 2015 14:01:34 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896863#M1011492 nagaiank 2015-05-07T14:01:34Z Re: How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896864#M1011493 <HTML><HEAD></HEAD><BODY><P>You can use FirstSortedValue() function in the front end or the script to achieve this.</P><P></P><P>FirstSortedValue takes the following inputs: see attached image</P><P></P><P><IMG alt="FirstSortedValue.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85948_FirstSortedValue.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 07 May 2015 14:03:02 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896864#M1011493 sunny_talwar 2015-05-07T14:03:02Z Re: How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896865#M1011494 <HTML><HEAD></HEAD><BODY><P>thanks. when I am using this it is not showing for each case. Instead showing overall latest values.</P><P></P><P>but I want for each case</P></BODY></HTML> Thu, 07 May 2015 14:15:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896865#M1011494 2015-05-07T14:15:00Z Re: How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896866#M1011495 <HTML><HEAD></HEAD><BODY><P>thanks. when I am using this it is not showing for each case. Instead showing overall latest values.</P><P></P><P>but I want for each case</P></BODY></HTML> Thu, 07 May 2015 14:15:12 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896866#M1011495 2015-05-07T14:15:12Z Re: How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896867#M1011497 <HTML><HEAD></HEAD><BODY><P>Can you share a sample application?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 07 May 2015 14:19:54 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896867#M1011497 sunny_talwar 2015-05-07T14:19:54Z Re: How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896868#M1011499 <HTML><HEAD></HEAD><BODY><P>use max(lastdate)</P></BODY></HTML> Thu, 07 May 2015 14:30:24 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896868#M1011499 2015-05-07T14:30:24Z Re: How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896869#M1011501 <HTML><HEAD></HEAD><BODY><P>Please see attached.</P></BODY></HTML> Thu, 07 May 2015 14:38:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896869#M1011501 2015-05-07T14:38:17Z Re: How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896870#M1011503 <HTML><HEAD></HEAD><BODY><P>Does this looks like what you wanted? (PFA)</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 07 May 2015 14:56:35 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896870#M1011503 sunny_talwar 2015-05-07T14:56:35Z Re: How to get values correspoding to latest date? https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896871#M1011505 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Fri, 08 May 2015 09:08:13 GMT https://community.qlik.com/t5/QlikView/How-to-get-values-correspoding-to-latest-date/m-p/896871#M1011505 2015-05-08T09:08:13Z