topic Re: Max String Question in QlikView https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791642#M1044508 <HTML><HEAD></HEAD><BODY><P>Sorry just tried and it said error ') expected</P></BODY></HTML> Thu, 20 Nov 2014 16:44:19 GMT 2014-11-20T16:44:19Z Max String Question https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791640#M1044505 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Bit stuck with this one, was trying to get the Max Wave for a particular leasing Company</P><P></P><P>I had this formula so far but doesn't seem to be working any ideas ? </P><P></P><P>=Max(&lt;[Leasing Company]=$(vLeaseCo),Wave)</P><P></P><P>Thanks</P><P><BR />Sarah </P></BODY></HTML> Thu, 20 Nov 2014 16:26:22 GMT https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791640#M1044505 2014-11-20T16:26:22Z Re: Max String Question https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791641#M1044507 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Max({$&lt;[Leasing Company]={'$(vLeaseCo)'}&gt;},Wave)</SPAN></P></BODY></HTML> Thu, 20 Nov 2014 16:33:51 GMT https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791641#M1044507 MarcoWedel 2014-11-20T16:33:51Z Re: Max String Question https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791642#M1044508 <HTML><HEAD></HEAD><BODY><P>Sorry just tried and it said error ') expected</P></BODY></HTML> Thu, 20 Nov 2014 16:44:19 GMT https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791642#M1044508 2014-11-20T16:44:19Z Re: Max String Question https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791643#M1044509 <HTML><HEAD></HEAD><BODY><P>If Wave is string, then use MaxString()</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">=Max({$&lt;[Leasing Company]={'$(vLeaseCo)'}&gt;}Wave)&nbsp; --Removed comma before Wave</SPAN></P></BODY></HTML> Thu, 20 Nov 2014 16:46:20 GMT https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791643#M1044509 anbu1984 2014-11-20T16:46:20Z Re: Max String Question https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791644#M1044510 <HTML><HEAD></HEAD><BODY><P>if it is a string you will need the maxstring() function</P></BODY></HTML> Thu, 20 Nov 2014 16:46:25 GMT https://community.qlik.com/t5/QlikView/Max-String-Question/m-p/791644#M1044510 2014-11-20T16:46:25Z