topic Max of a Count Distinct in QlikView https://community.qlik.com/t5/QlikView/Max-of-a-Count-Distinct/m-p/153697#M30639 <HTML><HEAD></HEAD><BODY><P>In my data we have transactions by customer Id.</P><P>I can do a count(Distinct custid) to find out how many unique customers i had over a period.</P><P>I can do count(distinct transId) to find out how many transactions i had over a period</P><P>What i would like to do now if to find what was the highest transaction count for the selected period by customer.</P><P>I don't need the customer itself, just the highest value.</P><P>Kind Regards</P></BODY></HTML> Thu, 10 Mar 2011 14:14:02 GMT 2011-03-10T14:14:02Z Max of a Count Distinct https://community.qlik.com/t5/QlikView/Max-of-a-Count-Distinct/m-p/153697#M30639 <HTML><HEAD></HEAD><BODY><P>In my data we have transactions by customer Id.</P><P>I can do a count(Distinct custid) to find out how many unique customers i had over a period.</P><P>I can do count(distinct transId) to find out how many transactions i had over a period</P><P>What i would like to do now if to find what was the highest transaction count for the selected period by customer.</P><P>I don't need the customer itself, just the highest value.</P><P>Kind Regards</P></BODY></HTML> Thu, 10 Mar 2011 14:14:02 GMT https://community.qlik.com/t5/QlikView/Max-of-a-Count-Distinct/m-p/153697#M30639 2011-03-10T14:14:02Z Max of a Count Distinct https://community.qlik.com/t5/QlikView/Max-of-a-Count-Distinct/m-p/153698#M30640 <HTML><HEAD></HEAD><BODY><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P style="font-weight: bold"></P><P style="font-weight: bold">Max</P><B></B><P style="font-weight: bold"></P><P></P><P>Seems to do it ....</P>(<B>Aggr</B>(<B>Count</B>(<B>Distinct</B> <B>[Trans Id]</B>), <B>[MailCount]</B>)) <BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 10 Mar 2011 14:19:24 GMT https://community.qlik.com/t5/QlikView/Max-of-a-Count-Distinct/m-p/153698#M30640 2011-03-10T14:19:24Z Max of a Count Distinct https://community.qlik.com/t5/QlikView/Max-of-a-Count-Distinct/m-p/153699#M30641 <HTML><HEAD></HEAD><BODY><P>Harry,<BR />From your description, it should be aggregated by customer:<BR />max(aggr(count(distinct transid),<STRONG>custid</STRONG>))</P></BODY></HTML> Thu, 10 Mar 2011 14:48:16 GMT https://community.qlik.com/t5/QlikView/Max-of-a-Count-Distinct/m-p/153699#M30641 Anonymous 2011-03-10T14:48:16Z