Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
ngrunoz
New 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

Re: Aggr Count Distinct

May be this

=Count(TOTAL DISTINCT [Miner name])


Capture.PNG

4 Replies

Re: Aggr Count Distinct

Don't see anything attached

ngrunoz
New Contributor II

Re: Aggr Count Distinct

Apologies.

Attached herewith.

Re: Aggr Count Distinct

May be this

=Count(TOTAL DISTINCT [Miner name])


Capture.PNG

ngrunoz
New Contributor II

Re: Aggr Count Distinct

Thank you so much.