topic Count including duplicates in QlikView https://community.qlik.com/t5/QlikView/Count-including-duplicates/m-p/375852#M140041 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 144pt; border-collapse: collapse;" width="192"><TBODY><TR style="height: 15pt;"><TD height="20" style="width: 48pt; height: 15pt;" width="64">Case No</TD><TD style="width: 48pt;" width="64">Category</TD><TD style="width: 48pt;" width="64">Sub category</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">216</TD><TD>A</TD><TD>C</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">216</TD><TD>B</TD><TD>C</TD></TR></TBODY></TABLE><P></P><P>I'm need to display count(CASE No) in titles of one of the charts. It gives count as 1.</P><P>Is there anyways I can get count including duplicates i.e; 2 in the above case</P></BODY></HTML> Thu, 29 Mar 2012 16:35:24 GMT 2012-03-29T16:35:24Z Count including duplicates https://community.qlik.com/t5/QlikView/Count-including-duplicates/m-p/375852#M140041 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 144pt; border-collapse: collapse;" width="192"><TBODY><TR style="height: 15pt;"><TD height="20" style="width: 48pt; height: 15pt;" width="64">Case No</TD><TD style="width: 48pt;" width="64">Category</TD><TD style="width: 48pt;" width="64">Sub category</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">216</TD><TD>A</TD><TD>C</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">216</TD><TD>B</TD><TD>C</TD></TR></TBODY></TABLE><P></P><P>I'm need to display count(CASE No) in titles of one of the charts. It gives count as 1.</P><P>Is there anyways I can get count including duplicates i.e; 2 in the above case</P></BODY></HTML> Thu, 29 Mar 2012 16:35:24 GMT https://community.qlik.com/t5/QlikView/Count-including-duplicates/m-p/375852#M140041 2012-03-29T16:35:24Z Count including duplicates https://community.qlik.com/t5/QlikView/Count-including-duplicates/m-p/375853#M140042 <HTML><HEAD></HEAD><BODY><P>Count should count duplicates...</P><P>When you dont want to count duplicates you use distinct</P></BODY></HTML> Thu, 29 Mar 2012 17:06:11 GMT https://community.qlik.com/t5/QlikView/Count-including-duplicates/m-p/375853#M140042 2012-03-29T17:06:11Z Count including duplicates https://community.qlik.com/t5/QlikView/Count-including-duplicates/m-p/375854#M140043 <HTML><HEAD></HEAD><BODY><P>Can you post your app, or at least the data model?</P></BODY></HTML> Thu, 29 Mar 2012 17:08:42 GMT https://community.qlik.com/t5/QlikView/Count-including-duplicates/m-p/375854#M140043 Jason_Michaelides 2012-03-29T17:08:42Z