https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1582898#M738976 <P>If&nbsp; you want count of distinct invoices by team members then use</P><P>Aggr(Count(distinct Invoice Field),Team Filed)</P><P>or&nbsp;</P><P>If you want count of distinct invoices by a specific team member then use</P><P>Count({&lt;Team Field = {'Field Value'}&gt;}distinct Invoice Field)</P> Tue, 21 May 2019 15:29:27 GMT Uday_Pasupuleti 2019-05-21T15:29:27Z https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1582888#M738974 <P>Need to get Invoice count for distinct team members. Using set analysis</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1582888#M738974 spandana8 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1582894#M738975 too little information.<BR />share some sample data, and sample output plus logic of what you need Tue, 21 May 2019 15:18:01 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1582894#M738975 dplr-rn 2019-05-21T15:18:01Z https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1582898#M738976 <P>If&nbsp; you want count of distinct invoices by team members then use</P><P>Aggr(Count(distinct Invoice Field),Team Filed)</P><P>or&nbsp;</P><P>If you want count of distinct invoices by a specific team member then use</P><P>Count({&lt;Team Field = {'Field Value'}&gt;}distinct Invoice Field)</P> Tue, 21 May 2019 15:29:27 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1582898#M738976 Uday_Pasupuleti 2019-05-21T15:29:27Z