Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)