Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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.

1 Solution

Accepted Solutions
sunny_talwar

May be this

=Count(TOTAL DISTINCT [Miner name])


Capture.PNG

View solution in original post

4 Replies
sunny_talwar

Don't see anything attached

ngrunoz
Contributor II
Contributor II
Author

Apologies.

Attached herewith.

sunny_talwar

May be this

=Count(TOTAL DISTINCT [Miner name])


Capture.PNG

ngrunoz
Contributor II
Contributor II
Author

Thank you so much.