Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Count Distinct

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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
Partner
Partner

too little information.
share some sample data, and sample output plus logic of what you need
Highlighted
Partner
Partner

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