topic Re: maxstring() help in QlikView https://community.qlik.com/t5/QlikView/maxstring-help/m-p/567350#M211599 <HTML><HEAD></HEAD><BODY><P>post your document</P></BODY></HTML> Thu, 27 Mar 2014 07:40:31 GMT alexandros17 2014-03-27T07:40:31Z maxstring() help https://community.qlik.com/t5/QlikView/maxstring-help/m-p/567349#M211598 <HTML><HEAD></HEAD><BODY><P>I am using maxstring function to select values from listbox and displaying corresponding data in pivot table. But when i clear my selections, the table remains populated with the data corresponding to the last value in the listbox.</P><P></P><P>Can anyone help me out how to remove that condition?</P></BODY></HTML> Thu, 27 Mar 2014 07:36:54 GMT https://community.qlik.com/t5/QlikView/maxstring-help/m-p/567349#M211598 mansi_dv 2014-03-27T07:36:54Z Re: maxstring() help https://community.qlik.com/t5/QlikView/maxstring-help/m-p/567350#M211599 <HTML><HEAD></HEAD><BODY><P>post your document</P></BODY></HTML> Thu, 27 Mar 2014 07:40:31 GMT https://community.qlik.com/t5/QlikView/maxstring-help/m-p/567350#M211599 alexandros17 2014-03-27T07:40:31Z Re: maxstring() help https://community.qlik.com/t5/QlikView/maxstring-help/m-p/567351#M211600 <HTML><HEAD></HEAD><BODY><P>hi</P><P><STRONG>MaxString() function--</STRONG></P><P>Returns the last text value of <SPAN class="italic;">expression</SPAN> over a number of records, as defined by a <SPAN class="Bold">group by</SPAN> clause. If no text value is found, NULL is returned. </P><P class="example">Example:</P><P class="Code">Load Month, MaxString(Month) as LastSalesMonth from abc.csv group by Year</P></BODY></HTML> Thu, 27 Mar 2014 07:44:59 GMT https://community.qlik.com/t5/QlikView/maxstring-help/m-p/567351#M211600 2014-03-27T07:44:59Z