topic Re: Select Max Value to display in text object in QlikView https://community.qlik.com/t5/QlikView/Select-Max-Value-to-display-in-text-object/m-p/1109246#M893806 <HTML><HEAD></HEAD><BODY><P>Try it with: firstsortedvalue(AMOUNT, -ID)</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 15 Aug 2016 11:48:46 GMT marcus_sommer 2016-08-15T11:48:46Z Select Max Value to display in text object https://community.qlik.com/t5/QlikView/Select-Max-Value-to-display-in-text-object/m-p/1109245#M893804 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Am trying to display a value in a text object based on the maximum value contained in the column which is the latest ID number:</P><P></P><P>The data is below:</P><P></P><P>ID, AMOUNT</P><P>1, 63636</P><P>2,83838</P><P>3,75757</P><P></P><P>I would like the value of 75757 displayed in the text box.</P><P></P><P>I have the following expression so far but cant figure out how to show the AMOUNT rather than the ID max number!</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Max</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">ID</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">AMOUNT</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Am new to Qlikview so please excuse me!</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">thanks</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Martin</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Select-Max-Value-to-display-in-text-object/m-p/1109245#M893804 martin_hamilton 2020-11-25T16:16:04Z Re: Select Max Value to display in text object https://community.qlik.com/t5/QlikView/Select-Max-Value-to-display-in-text-object/m-p/1109246#M893806 <HTML><HEAD></HEAD><BODY><P>Try it with: firstsortedvalue(AMOUNT, -ID)</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 15 Aug 2016 11:48:46 GMT https://community.qlik.com/t5/QlikView/Select-Max-Value-to-display-in-text-object/m-p/1109246#M893806 marcus_sommer 2016-08-15T11:48:46Z Re: Select Max Value to display in text object https://community.qlik.com/t5/QlikView/Select-Max-Value-to-display-in-text-object/m-p/1109247#M893808 <HTML><HEAD></HEAD><BODY><P>Thanks Marcus!</P></BODY></HTML> Mon, 15 Aug 2016 11:53:58 GMT https://community.qlik.com/t5/QlikView/Select-Max-Value-to-display-in-text-object/m-p/1109247#M893808 martin_hamilton 2016-08-15T11:53:58Z