topic getting duplicates when using count(if in QlikView https://community.qlik.com/t5/QlikView/getting-duplicates-when-using-count-if/m-p/244609#M93276 <HTML><HEAD></HEAD><BODY><P> After writing the post, I realized that I had duplicates in my master calendar months</P></BODY></HTML> Wed, 01 Feb 2012 17:57:26 GMT 2012-02-01T17:57:26Z getting duplicates when using count(if https://community.qlik.com/t5/QlikView/getting-duplicates-when-using-count-if/m-p/244608#M93275 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>When I have a set of data where there is a create date and a ticket number.&nbsp; Then I created a master calendar so I can create a bar chart where the dimension is the month name of the master calendar.&nbsp; </P><P></P><P>When I use count(if(month_master = mont_create, id)) i'm getting duplicate information and my count is wrong.&nbsp; However, when I use count(distinct(if (month_master = mont_create, id))), the count is correct.</P><P></P><P>I verified my data doesn't have duplicates by doing a count(id) and count(distinct(id)).</P><P></P><P>When I created a simple test file, it seems to work also.&nbsp; I'm at a lost how I can continue to troushoot this error.</P><P></P><P>At this time, I'm unable to upload the .qvw file.</P><P></P><P>Any help is appreciated.</P></BODY></HTML> Wed, 01 Feb 2012 17:55:12 GMT https://community.qlik.com/t5/QlikView/getting-duplicates-when-using-count-if/m-p/244608#M93275 2012-02-01T17:55:12Z getting duplicates when using count(if https://community.qlik.com/t5/QlikView/getting-duplicates-when-using-count-if/m-p/244609#M93276 <HTML><HEAD></HEAD><BODY><P> After writing the post, I realized that I had duplicates in my master calendar months</P></BODY></HTML> Wed, 01 Feb 2012 17:57:26 GMT https://community.qlik.com/t5/QlikView/getting-duplicates-when-using-count-if/m-p/244609#M93276 2012-02-01T17:57:26Z