topic Count Distinct query in QlikView https://community.qlik.com/t5/QlikView/Count-Distinct-query/m-p/893750#M998292 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a query with two different expressions I am using. I am looking to show YTD 2015 completed activities and A) gives me circa 500 where B) gives me 5,000. I am failing to understand why there is such a huge difference in the outcomes and was wondering if anyone could shed some light on this? And possibly the correct one to use! Thank in advance.</P><P></P><P>A) =count(distinct(if(InYear([Activity.Completed Date], Today(), 0), [Activity Id], )))</P><P></P><P></P><P>B) =Count(Distinct If([Activity.Status]='Completed' AND [Activity.Completed Date],&nbsp; Today(),[Activity Id],)) </P></BODY></HTML> Wed, 24 Jun 2015 15:02:43 GMT knightwriter 2015-06-24T15:02:43Z Count Distinct query https://community.qlik.com/t5/QlikView/Count-Distinct-query/m-p/893750#M998292 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a query with two different expressions I am using. I am looking to show YTD 2015 completed activities and A) gives me circa 500 where B) gives me 5,000. I am failing to understand why there is such a huge difference in the outcomes and was wondering if anyone could shed some light on this? And possibly the correct one to use! Thank in advance.</P><P></P><P>A) =count(distinct(if(InYear([Activity.Completed Date], Today(), 0), [Activity Id], )))</P><P></P><P></P><P>B) =Count(Distinct If([Activity.Status]='Completed' AND [Activity.Completed Date],&nbsp; Today(),[Activity Id],)) </P></BODY></HTML> Wed, 24 Jun 2015 15:02:43 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-query/m-p/893750#M998292 knightwriter 2015-06-24T15:02:43Z