topic Re: First Sorted Value with Set analysis in QlikView https://community.qlik.com/t5/QlikView/First-Sorted-Value-with-Set-analysis/m-p/1113853#M367958 <HTML><HEAD></HEAD><BODY><P>I got it,&nbsp; StartDate and EndDate are not formatted to Dates.</P><P></P><P>Please find attached qvw second straight table and edit script for the formatting of dates</P></BODY></HTML> Tue, 16 Aug 2016 08:02:56 GMT kkkumar82 2016-08-16T08:02:56Z First Sorted Value with Set analysis https://community.qlik.com/t5/QlikView/First-Sorted-Value-with-Set-analysis/m-p/1113852#M367957 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I require a small help in first sorted value with set analysis.</P><P></P><P>Scenario.</P><P>I have EMPID with Start end and end Dates, First sorted value is working fine with only the recent end date but my requirement is I have to give a date in an input box and I want a recent employee who start date &lt;= vAsofDate and EndDate &gt;=vAsofDate.</P><P></P><P></P><P></P><P>The problematic table is the second straight table.</P><P></P><P>Any help ??</P></BODY></HTML> Tue, 16 Aug 2016 07:51:50 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value-with-Set-analysis/m-p/1113852#M367957 kkkumar82 2016-08-16T07:51:50Z Re: First Sorted Value with Set analysis https://community.qlik.com/t5/QlikView/First-Sorted-Value-with-Set-analysis/m-p/1113853#M367958 <HTML><HEAD></HEAD><BODY><P>I got it,&nbsp; StartDate and EndDate are not formatted to Dates.</P><P></P><P>Please find attached qvw second straight table and edit script for the formatting of dates</P></BODY></HTML> Tue, 16 Aug 2016 08:02:56 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value-with-Set-analysis/m-p/1113853#M367958 kkkumar82 2016-08-16T08:02:56Z