topic Expression help please. in QlikView https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1424249#M800839 <HTML><HEAD></HEAD><BODY><P>I have the file attached and QVW.</P><P></P><P>I want to show the phase which has Yes based on the latest Phaseno.</P><P></P><P>Ex: Prj - 151 should show Const and Prj - 152 should show Due.</P><P></P><P>How can I do this ?</P><P></P><P>Thank you,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT apthansh 2020-11-25T16:16:04Z Expression help please. https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1424249#M800839 <HTML><HEAD></HEAD><BODY><P>I have the file attached and QVW.</P><P></P><P>I want to show the phase which has Yes based on the latest Phaseno.</P><P></P><P>Ex: Prj - 151 should show Const and Prj - 152 should show Due.</P><P></P><P>How can I do this ?</P><P></P><P>Thank you,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1424249#M800839 apthansh 2020-11-25T16:16:04Z Re: Expression help please. https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1424250#M800840 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>FirstSortedValue({&lt;YesNo = {'Yes'}&gt;} Phase, -PhaseNo)</STRONG></P></BODY></HTML> Tue, 05 Dec 2017 04:07:25 GMT https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1424250#M800840 Anil_Babu_Samineni 2017-12-05T04:07:25Z Re: Expression help please. https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1424251#M800841 <HTML><HEAD></HEAD><BODY><P>Awsomenesssss.Thank you very much.</P></BODY></HTML> Tue, 05 Dec 2017 12:45:09 GMT https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1424251#M800841 apthansh 2017-12-05T12:45:09Z