topic Re: first sorted value with multiple activities on one date in QlikView https://community.qlik.com/t5/QlikView/first-sorted-value-with-multiple-activities-on-one-date/m-p/384513#M143630 <HTML><HEAD></HEAD><BODY><P>You can't find SMC by date with FSV, because SMC and SOE has the same date.</P></BODY></HTML> Wed, 05 Sep 2012 15:59:39 GMT whiteline 2012-09-05T15:59:39Z first sorted value with multiple activities on one date https://community.qlik.com/t5/QlikView/first-sorted-value-with-multiple-activities-on-one-date/m-p/384512#M143629 <HTML><HEAD></HEAD><BODY><P>I need to screen for certain activities. Here's the list for one customer:</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp; Activity</P><P>8/28&nbsp;&nbsp;&nbsp;&nbsp; SOE</P><P>8/28&nbsp;&nbsp;&nbsp;&nbsp; SMC</P><P>8/26&nbsp;&nbsp;&nbsp;&nbsp; SNC&nbsp;&nbsp;&nbsp;&nbsp; </P><P>8/26&nbsp;&nbsp;&nbsp;&nbsp; SNC</P><P></P><P>I want to find the SMC activity, but when I try FirstSortedValue (FSV) as FSV(Activity,-Date,1), FSV(Activity,-Date,2),FSV(Activity,-Date,3),</P><P>my results are "SOE", "SNC", "SNC". What am I doing wrong?</P></BODY></HTML> Wed, 05 Sep 2012 15:23:00 GMT https://community.qlik.com/t5/QlikView/first-sorted-value-with-multiple-activities-on-one-date/m-p/384512#M143629 2012-09-05T15:23:00Z Re: first sorted value with multiple activities on one date https://community.qlik.com/t5/QlikView/first-sorted-value-with-multiple-activities-on-one-date/m-p/384513#M143630 <HTML><HEAD></HEAD><BODY><P>You can't find SMC by date with FSV, because SMC and SOE has the same date.</P></BODY></HTML> Wed, 05 Sep 2012 15:59:39 GMT https://community.qlik.com/t5/QlikView/first-sorted-value-with-multiple-activities-on-one-date/m-p/384513#M143630 whiteline 2012-09-05T15:59:39Z