topic To get the last record from a list in QlikView https://community.qlik.com/t5/QlikView/To-get-the-last-record-from-a-list/m-p/354#M792578 <HTML><HEAD></HEAD><BODY><P>I have a listbox name Quarter with values Q1,Q2,Q3,Q4. I can use the GetFieldSelections(Quarter) to get the field selections for Quarter. However I need to find the last selected value. For Example if the user selected Q1,Q2,Q3 , the result should give me Q3 . How do I achieve this ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z To get the last record from a list https://community.qlik.com/t5/QlikView/To-get-the-last-record-from-a-list/m-p/354#M792578 <HTML><HEAD></HEAD><BODY><P>I have a listbox name Quarter with values Q1,Q2,Q3,Q4. I can use the GetFieldSelections(Quarter) to get the field selections for Quarter. However I need to find the last selected value. For Example if the user selected Q1,Q2,Q3 , the result should give me Q3 . How do I achieve this ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/To-get-the-last-record-from-a-list/m-p/354#M792578 Anonymous 2020-11-25T16:16:04Z Re: To get the last record from a list https://community.qlik.com/t5/QlikView/To-get-the-last-record-from-a-list/m-p/355#M792579 <HTML><HEAD></HEAD><BODY><P>May be use <SPAN style="font-size: 10pt;"><STRONG>=</STRONG></SPAN><STRONG style="font-size: 10pt;">MaxString(Quarter)</STRONG></P></BODY></HTML> Sat, 13 Jan 2018 17:14:04 GMT https://community.qlik.com/t5/QlikView/To-get-the-last-record-from-a-list/m-p/355#M792579 Anil_Babu_Samineni 2018-01-13T17:14:04Z Re: To get the last record from a list https://community.qlik.com/t5/QlikView/To-get-the-last-record-from-a-list/m-p/356#M792580 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Yes Anil Suggested maxstring function should work and u can get the desired result using text box object.</P><P>check below article from Robert Mika</P><P><A href="https://community.qlik.com/docs/DOC-8019">How to use - MaxString &amp;amp; MinString</A></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189985_Capture.JPG" style="height: 275px; width: 620px;" /></P></BODY></HTML> Sat, 13 Jan 2018 17:31:09 GMT https://community.qlik.com/t5/QlikView/To-get-the-last-record-from-a-list/m-p/356#M792580 devarasu07 2018-01-13T17:31:09Z Re: To get the last record from a list https://community.qlik.com/t5/QlikView/To-get-the-last-record-from-a-list/m-p/357#M792581 <HTML><HEAD></HEAD><BODY><P>Thanks guys!!!.. This is what I needed!!</P></BODY></HTML> Sat, 13 Jan 2018 17:52:11 GMT https://community.qlik.com/t5/QlikView/To-get-the-last-record-from-a-list/m-p/357#M792581 Anonymous 2018-01-13T17:52:11Z