topic Re: Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/619427#M228150 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; i want to show the date also for that status</P></BODY></HTML> Fri, 07 Feb 2014 09:19:41 GMT 2014-02-07T09:19:41Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/619423#M228146 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>&nbsp;&nbsp;&nbsp; I have a scenario like this, i need to show the recent status for every 'id' PFA . I need to show that in straight table</P><P>with out any selections</P></BODY></HTML> Fri, 07 Feb 2014 08:10:45 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/619423#M228146 2014-02-07T08:10:45Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/619424#M228147 <HTML><HEAD></HEAD><BODY><P>Check enclosed file</P></BODY></HTML> Fri, 07 Feb 2014 08:22:33 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/619424#M228147 MK_QSL 2014-02-07T08:22:33Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/619425#M228148 <HTML><HEAD></HEAD><BODY><P>check enclosed file</P></BODY></HTML> Fri, 07 Feb 2014 08:22:55 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/619425#M228148 MK_QSL 2014-02-07T08:22:55Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/619426#M228149 <HTML><HEAD></HEAD><BODY><P>Use FIRSTSORTEDVALUE</P></BODY></HTML> Fri, 07 Feb 2014 08:37:03 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/619426#M228149 rustyfishbones 2014-02-07T08:37:03Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/619427#M228150 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; i want to show the date also for that status</P></BODY></HTML> Fri, 07 Feb 2014 09:19:41 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/619427#M228150 2014-02-07T09:19:41Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/619428#M228151 <HTML><HEAD></HEAD><BODY><P>Try below, you may need to format the Date</P><P></P><P>DATE(FirstSortedValue(date,-date),'DD/MM/YYYY')</P></BODY></HTML> Fri, 07 Feb 2014 09:32:39 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/619428#M228151 rustyfishbones 2014-02-07T09:32:39Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/619429#M228152 <HTML><HEAD></HEAD><BODY><P>Try FirstSortedValue(date,-date)</P></BODY></HTML> Fri, 07 Feb 2014 09:38:51 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/619429#M228152 MK_QSL 2014-02-07T09:38:51Z