topic Text box expression in QlikView https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1422864#M429007 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i need to show Latest Month and cycle field in text box . my month field is like C10 2017, C92017 ,C82017. i can not do max as we i have all the 12&nbsp; cycle in data all the time.<BR /> but i have a column in data that tell&nbsp; this is latest cycle.)</P><P> Month field&nbsp; column <BR /> c10 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Latest cycle<BR /> c10 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Latest cycle<BR />.</P><P>.<BR />.<BR /> c09 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Last cycle</P><P>i want to show Last cycle Month field in text box.</P><P>TIA!</P></BODY></HTML> Mon, 20 Nov 2017 11:07:14 GMT yogitamehta10 2017-11-20T11:07:14Z Text box expression https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1422864#M429007 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i need to show Latest Month and cycle field in text box . my month field is like C10 2017, C92017 ,C82017. i can not do max as we i have all the 12&nbsp; cycle in data all the time.<BR /> but i have a column in data that tell&nbsp; this is latest cycle.)</P><P> Month field&nbsp; column <BR /> c10 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Latest cycle<BR /> c10 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Latest cycle<BR />.</P><P>.<BR />.<BR /> c09 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Last cycle</P><P>i want to show Last cycle Month field in text box.</P><P>TIA!</P></BODY></HTML> Mon, 20 Nov 2017 11:07:14 GMT https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1422864#M429007 yogitamehta10 2017-11-20T11:07:14Z Re: Text box expression https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1422865#M429008 <HTML><HEAD></HEAD><BODY><P>Try this ?</P><P>Only({&lt;column = {'Last cycle'}&gt;}[Month field])</P></BODY></HTML> Mon, 20 Nov 2017 11:10:46 GMT https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1422865#M429008 woshua5550 2017-11-20T11:10:46Z