topic Re: Please help me to form this set expression in QlikView https://community.qlik.com/t5/QlikView/Please-help-me-to-form-this-set-expression/m-p/514524#M483565 <HTML><HEAD></HEAD><BODY><P>Hi Vishnu,</P><P></P><P>Not sure you try this yet =Only({$&lt;gift_date = {$(=Max(gift_date))}&gt;} gift_type)</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Thu, 27 Jun 2013 07:00:17 GMT Sokkorn 2013-06-27T07:00:17Z Please help me to form this set expression https://community.qlik.com/t5/QlikView/Please-help-me-to-form-this-set-expression/m-p/514523#M483564 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a qlikview internal table that contains information like student_id, gift_id, gift_date, gift_type etc.</P><P>In a straight table, i need to display against each student_id, the latest gift_date, its corresponding gift_id, gift_type etc.</P><P>The latest gift_date of course can be found using max(gift_date). But for its corresponding gift type, what i tried was something like </P><P>=if(gift_date=max(gift_date),gift_id) .. and this seems logically wrong.</P><P></P><P>Can anyone please help me with this?</P><P></P><P>Regards,</P><P>Vishnu</P></BODY></HTML> Thu, 27 Jun 2013 06:55:28 GMT https://community.qlik.com/t5/QlikView/Please-help-me-to-form-this-set-expression/m-p/514523#M483564 vishnus85 2013-06-27T06:55:28Z Re: Please help me to form this set expression https://community.qlik.com/t5/QlikView/Please-help-me-to-form-this-set-expression/m-p/514524#M483565 <HTML><HEAD></HEAD><BODY><P>Hi Vishnu,</P><P></P><P>Not sure you try this yet =Only({$&lt;gift_date = {$(=Max(gift_date))}&gt;} gift_type)</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Thu, 27 Jun 2013 07:00:17 GMT https://community.qlik.com/t5/QlikView/Please-help-me-to-form-this-set-expression/m-p/514524#M483565 Sokkorn 2013-06-27T07:00:17Z Re: Please help me to form this set expression https://community.qlik.com/t5/QlikView/Please-help-me-to-form-this-set-expression/m-p/514525#M483566 <HTML><HEAD></HEAD><BODY><P>Try FirstSortedValue() function like:</P><P></P><P>firstsortedvalue(gift_id, - gift_date)</P></BODY></HTML> Thu, 27 Jun 2013 07:01:14 GMT https://community.qlik.com/t5/QlikView/Please-help-me-to-form-this-set-expression/m-p/514525#M483566 tresB 2013-06-27T07:01:14Z