Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
spandana8
Contributor
Contributor

Count Distinct

Need to get Invoice count for distinct team members. Using set analysis

1 Solution

Accepted Solutions
Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

If  you want count of distinct invoices by team members then use

Aggr(Count(distinct Invoice Field),Team Filed)

or 

If you want count of distinct invoices by a specific team member then use

Count({<Team Field = {'Field Value'}>}distinct Invoice Field)

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

too little information.
share some sample data, and sample output plus logic of what you need
Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

If  you want count of distinct invoices by team members then use

Aggr(Count(distinct Invoice Field),Team Filed)

or 

If you want count of distinct invoices by a specific team member then use

Count({<Team Field = {'Field Value'}>}distinct Invoice Field)