https://community.qlik.com/t5/QlikView/Using-Max-Aggr-and-Count-together/m-p/1631227#M446470 <P>How about this</P><LI-CODE lang="markup">=Count(DISTINCT {&lt;[PO#] = {"=Max(Aggr(Count(DISTINCT EDI_UPC), PO#, EDI_CARTON_NUMBER)) = 1"}&gt;} [PO#])</LI-CODE> Thu, 03 Oct 2019 17:52:17 GMT sunny_talwar 2019-10-03T17:52:17Z https://community.qlik.com/t5/QlikView/Using-Max-Aggr-and-Count-together/m-p/1631223#M446469 <P>Having trouble with the following expression.&nbsp;</P><P>=count(distinct if(max(aggr(count(distinct EDI_UPC),PO#,EDI_CARTON_NUMBER))=1,PO#))</P><P>I'm attempting to count the number of PO#'s that have a maximum of 1 EDI_UPC in any EDI_CARTON_NUMBER.</P><P>This portion of the expression is working fine:</P><P>=max(aggr(count(distinct EDI_UPC),PO#,EDI_CARTON_NUMBER))</P><P>&nbsp;</P> Sat, 16 Nov 2024 02:18:52 GMT https://community.qlik.com/t5/QlikView/Using-Max-Aggr-and-Count-together/m-p/1631223#M446469 scott_brown 2024-11-16T02:18:52Z https://community.qlik.com/t5/QlikView/Using-Max-Aggr-and-Count-together/m-p/1631227#M446470 <P>How about this</P><LI-CODE lang="markup">=Count(DISTINCT {&lt;[PO#] = {"=Max(Aggr(Count(DISTINCT EDI_UPC), PO#, EDI_CARTON_NUMBER)) = 1"}&gt;} [PO#])</LI-CODE> Thu, 03 Oct 2019 17:52:17 GMT https://community.qlik.com/t5/QlikView/Using-Max-Aggr-and-Count-together/m-p/1631227#M446470 sunny_talwar 2019-10-03T17:52:17Z