topic Re: Aggr Count Distinct in QlikView https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312053#M838739 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Count(TOTAL DISTINCT [Miner name])</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162659_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Tue, 09 May 2017 16:06:13 GMT sunny_talwar 2017-05-09T16:06:13Z Aggr Count Distinct https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312050#M838736 <HTML><HEAD></HEAD><BODY><P>Hi Guys.</P><P></P><P>I have attached a document with Sample data and another tab with desired results.</P><P></P><P>I want to create a table&nbsp; with Data from column A to H and&nbsp; Aggr count distinct&nbsp; Miner name that I get the total number of miners irrespectively of the section they were involved in at that pint in time.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312050#M838736 ngrunoz 2020-11-25T16:16:04Z Re: Aggr Count Distinct https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312051#M838737 <HTML><HEAD></HEAD><BODY><P>Don't see anything attached</P></BODY></HTML> Tue, 09 May 2017 15:56:57 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312051#M838737 sunny_talwar 2017-05-09T15:56:57Z Re: Aggr Count Distinct https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312052#M838738 <HTML><HEAD></HEAD><BODY><P>Apologies.</P><P></P><P>Attached herewith.</P></BODY></HTML> Tue, 09 May 2017 16:03:32 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312052#M838738 ngrunoz 2017-05-09T16:03:32Z Re: Aggr Count Distinct https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312053#M838739 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Count(TOTAL DISTINCT [Miner name])</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162659_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Tue, 09 May 2017 16:06:13 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312053#M838739 sunny_talwar 2017-05-09T16:06:13Z Re: Aggr Count Distinct https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312054#M838740 <HTML><HEAD></HEAD><BODY><P>Thank you so much.</P></BODY></HTML> Wed, 10 May 2017 08:43:17 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-Distinct/m-p/1312054#M838740 ngrunoz 2017-05-10T08:43:17Z