topic aggr & max in QlikView https://community.qlik.com/t5/QlikView/aggr-max/m-p/188573#M51778 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P>I need to get the contact type of a mem no based on the max log id.</P><P>E.G. from a table list</P><P>MEM NO LOG ID CONTACT TYPE<BR />1 12 Successful<BR />2 13 Successful<BR />3 14 Successful<BR />4 15 Successful<BR />4 16 Unuccessful</P><P>I need to get the following on a pivot chart</P><P>MEM NO CONTACT TYPE<BR />1 Successful<BR />2 Successful<BR />3 Successful<BR />4 Unuccessful</P><P>Any ideas on how to do this using Aggr or other?</P><P>Thanks,<BR />Kevin.</P></BODY></HTML> Wed, 16 Sep 2009 19:42:19 GMT 2009-09-16T19:42:19Z aggr & max https://community.qlik.com/t5/QlikView/aggr-max/m-p/188573#M51778 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P>I need to get the contact type of a mem no based on the max log id.</P><P>E.G. from a table list</P><P>MEM NO LOG ID CONTACT TYPE<BR />1 12 Successful<BR />2 13 Successful<BR />3 14 Successful<BR />4 15 Successful<BR />4 16 Unuccessful</P><P>I need to get the following on a pivot chart</P><P>MEM NO CONTACT TYPE<BR />1 Successful<BR />2 Successful<BR />3 Successful<BR />4 Unuccessful</P><P>Any ideas on how to do this using Aggr or other?</P><P>Thanks,<BR />Kevin.</P></BODY></HTML> Wed, 16 Sep 2009 19:42:19 GMT https://community.qlik.com/t5/QlikView/aggr-max/m-p/188573#M51778 2009-09-16T19:42:19Z aggr & max https://community.qlik.com/t5/QlikView/aggr-max/m-p/188574#M51779 <HTML><HEAD></HEAD><BODY><P>Hi Kevin,</P><P>so far I see you can solve your problem in the same way as the attached application shows.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Wed, 16 Sep 2009 20:12:37 GMT https://community.qlik.com/t5/QlikView/aggr-max/m-p/188574#M51779 2009-09-16T20:12:37Z aggr & max https://community.qlik.com/t5/QlikView/aggr-max/m-p/188575#M51780 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>MAXSTRING((IF([LOG ID] = AGGR(NODISTINCT MAX([LOG ID]),MEMNO),[CONTACT TYPE],'-')))</P></BODY></HTML> Wed, 16 Sep 2009 20:23:49 GMT https://community.qlik.com/t5/QlikView/aggr-max/m-p/188575#M51780 Anonymous 2009-09-16T20:23:49Z