topic Re: Aggregate function on a set of aggregate functions in QlikView https://community.qlik.com/t5/QlikView/Aggregate-function-on-a-set-of-aggregate-functions/m-p/349790#M1170694 <HTML><HEAD></HEAD><BODY><P>That works, thanks</P></BODY></HTML> Fri, 13 Jul 2012 10:49:58 GMT 2012-07-13T10:49:58Z Aggregate function on a set of aggregate functions https://community.qlik.com/t5/QlikView/Aggregate-function-on-a-set-of-aggregate-functions/m-p/349788#M1170692 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Quick question, I am trying to get the max value from multiple counts/freqs.I tried something like the below but it doesn't work.</P><P></P><P>Any ideas?</P><P></P><P>= Max(</P><P>Count(field1),<BR />Count(field2),<BR />Count(field3)<BR />)</P><P></P><P></P><P>Regards</P><P></P><P>Revlin</P></BODY></HTML> Fri, 13 Jul 2012 10:12:17 GMT https://community.qlik.com/t5/QlikView/Aggregate-function-on-a-set-of-aggregate-functions/m-p/349788#M1170692 2012-07-13T10:12:17Z Re: Aggregate function on a set of aggregate functions https://community.qlik.com/t5/QlikView/Aggregate-function-on-a-set-of-aggregate-functions/m-p/349789#M1170693 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">= <STRONG>RangeMax</STRONG>(</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">Count(field1),<BR />Count(field2),<BR />Count(field3)<BR />)</P></BODY></HTML> Fri, 13 Jul 2012 10:35:39 GMT https://community.qlik.com/t5/QlikView/Aggregate-function-on-a-set-of-aggregate-functions/m-p/349789#M1170693 swuehl 2012-07-13T10:35:39Z Re: Aggregate function on a set of aggregate functions https://community.qlik.com/t5/QlikView/Aggregate-function-on-a-set-of-aggregate-functions/m-p/349790#M1170694 <HTML><HEAD></HEAD><BODY><P>That works, thanks</P></BODY></HTML> Fri, 13 Jul 2012 10:49:58 GMT https://community.qlik.com/t5/QlikView/Aggregate-function-on-a-set-of-aggregate-functions/m-p/349790#M1170694 2012-07-13T10:49:58Z