Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
ngrunoz
Contributor II
Contributor II

Aggr Count Distinct

Hi Guys.

I have attached a document with Sample data and another tab with desired results.

I want to create a table  with Data from column A to H and  Aggr count distinct  Miner name that I get the total number of miners irrespectively of the section they were involved in at that pint in time.

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

May be this

=Count(TOTAL DISTINCT [Miner name])


Capture.PNG

View solution in original post

4 Replies
sunny_talwar
MVP
MVP

Don't see anything attached

ngrunoz
Contributor II
Contributor II
Author

Apologies.

Attached herewith.

sunny_talwar
MVP
MVP

May be this

=Count(TOTAL DISTINCT [Miner name])


Capture.PNG

ngrunoz
Contributor II
Contributor II
Author

Thank you so much.