topic Re: Count after a distinct in QlikView https://community.qlik.com/t5/QlikView/Count-after-a-distinct/m-p/1213300#M848800 <HTML><HEAD></HEAD><BODY><P>Seems to be working.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 15 Mar 2017 16:20:55 GMT 2017-03-15T16:20:55Z Count after a distinct https://community.qlik.com/t5/QlikView/Count-after-a-distinct/m-p/1213298#M848796 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I'm trying to count a section after distinguishing another section. Here is what I'm trying to achieve (but obviously doesn't work) : </P><P>Distinct(ID_Company) then Count(Status_Company)</P><P></P><P>How can I manage to accomplish that.</P><P></P><P>Thanks in advance !</P><P></P><P>Alex</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-after-a-distinct/m-p/1213298#M848796 2020-11-25T16:16:04Z Re: Count after a distinct https://community.qlik.com/t5/QlikView/Count-after-a-distinct/m-p/1213299#M848797 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Aggr(Count(DISTINCT Status_Company), ID_Company))</STRONG></P></BODY></HTML> Wed, 15 Mar 2017 16:16:11 GMT https://community.qlik.com/t5/QlikView/Count-after-a-distinct/m-p/1213299#M848797 sunny_talwar 2017-03-15T16:16:11Z Re: Count after a distinct https://community.qlik.com/t5/QlikView/Count-after-a-distinct/m-p/1213300#M848800 <HTML><HEAD></HEAD><BODY><P>Seems to be working.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 15 Mar 2017 16:20:55 GMT https://community.qlik.com/t5/QlikView/Count-after-a-distinct/m-p/1213300#M848800 2017-03-15T16:20:55Z