topic Re: IMPORTANT!!! How to achieve the current activity record? in QlikView https://community.qlik.com/t5/QlikView/test/m-p/570264#M212475 <HTML><HEAD></HEAD><BODY><P>Probably doable with the firstsortedvalue function. Something like:</P><P>firstsortedvalue({&lt;[Contract Flag]={'C'}&gt;}[Contract Numb], [Contract Start])</P><P></P><P>But I can't really tell without looking at your document. I haven't passed my Screenshot Scrying exam yet.</P></BODY></HTML> Tue, 11 Feb 2014 17:24:57 GMT Gysbert_Wassenaar 2014-02-11T17:24:57Z test https://community.qlik.com/t5/QlikView/test/m-p/570263#M212474 <HTML><HEAD></HEAD><BODY><P>test</P></BODY></HTML> Tue, 11 Feb 2014 17:00:17 GMT https://community.qlik.com/t5/QlikView/test/m-p/570263#M212474 2014-02-11T17:00:17Z Re: IMPORTANT!!! How to achieve the current activity record? https://community.qlik.com/t5/QlikView/test/m-p/570264#M212475 <HTML><HEAD></HEAD><BODY><P>Probably doable with the firstsortedvalue function. Something like:</P><P>firstsortedvalue({&lt;[Contract Flag]={'C'}&gt;}[Contract Numb], [Contract Start])</P><P></P><P>But I can't really tell without looking at your document. I haven't passed my Screenshot Scrying exam yet.</P></BODY></HTML> Tue, 11 Feb 2014 17:24:57 GMT https://community.qlik.com/t5/QlikView/test/m-p/570264#M212475 Gysbert_Wassenaar 2014-02-11T17:24:57Z