topic Replace count (distinct) in QlikView https://community.qlik.com/t5/QlikView/Replace-count-distinct/m-p/393305#M489269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><BR />I have a expression which has Count(Distinct EmpID).</P><P>I saw the community, they have told that not to use Count(Distinct) as much as possible.</P><P>so by which other expression i can replace count(distinct)?</P></BODY></HTML> Fri, 30 Nov 2012 06:30:34 GMT udaya_kumar 2012-11-30T06:30:34Z Replace count (distinct) https://community.qlik.com/t5/QlikView/Replace-count-distinct/m-p/393305#M489269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><BR />I have a expression which has Count(Distinct EmpID).</P><P>I saw the community, they have told that not to use Count(Distinct) as much as possible.</P><P>so by which other expression i can replace count(distinct)?</P></BODY></HTML> Fri, 30 Nov 2012 06:30:34 GMT https://community.qlik.com/t5/QlikView/Replace-count-distinct/m-p/393305#M489269 udaya_kumar 2012-11-30T06:30:34Z Re: Replace count (distinct) https://community.qlik.com/t5/QlikView/Replace-count-distinct/m-p/393306#M489270 <HTML><HEAD></HEAD><BODY><P>Well, if you can load the data in a distinct way in the script already there's no need for the count(distinct ). It does require a little bit of data model review to see if there's a viable way of replacing the count(distinct) functions from your front end.</P></BODY></HTML> Fri, 30 Nov 2012 06:35:05 GMT https://community.qlik.com/t5/QlikView/Replace-count-distinct/m-p/393306#M489270 Anonymous 2012-11-30T06:35:05Z