topic Re: count data in QlikView https://community.qlik.com/t5/QlikView/count-data/m-p/1152026#M906885 <HTML><HEAD></HEAD><BODY><P>Simply write:</P><P>count(CLM_XGEN_CLAIM_NUM)</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/128488_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 20 Jun 2016 10:03:49 GMT varshavig12 2016-06-20T10:03:49Z count data https://community.qlik.com/t5/QlikView/count-data/m-p/1152025#M906884 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">want a help in this table </P><P style="font-size: 13.3333px;">clm_xgen_claim_num is also showing one time as it should show 2 and</P><P style="font-size: 13.3333px;">the yellow colour data is not getting count properly its showing only one time in blue but its should show 2 .</P><P style="font-size: 13.3333px;">so how to do it </P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellspacing="0" style="font-size: 13.3333px;"><TBODY><TR><TD bgcolor="#F5F5F5" height="20" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">HOSPITAL_NAME</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">HOSPITAL_CODE</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">CLM_XGEN_CLAIM_NUM</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">CLM_INTIMATION_DATE</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Clm_Type</STRONG></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">ICD_CODE_LEVEL1_org</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">total count of claims</SPAN></TD><TD bgcolor="#00FFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">ICD Code Blacklist</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">ADARSHA SPECIALITY HOSPITAL</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">HEGIC-HS-59905</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RR-HS15-10333805</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">21-Jan-2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">REIMBURSMENT</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">O80.9</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1</SPAN></TD><TD bgcolor="#00FFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">ADARSHA SPECIALITY HOSPITAL</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">HEGIC-HS-59905</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RR-HS15-10333805</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">21-Jan-2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">REIMBURSMENT</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">O82.0</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1</SPAN></TD><TD bgcolor="#00FFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">0</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">ADARSHA SPECIALITY HOSPITAL</SPAN></TD><TD bgcolor="#F5F5F5"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">Total</STRONG></TD><TD bgcolor="#F5F5F5"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;"><BR /></STRONG></TD><TD bgcolor="#F5F5F5"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;"><BR /></STRONG></TD><TD bgcolor="#F5F5F5"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;"><BR /></STRONG></TD><TD bgcolor="#F5F5F5"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;"><BR /></STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">1</STRONG></TD><TD bgcolor="#00FFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">1<BR /><BR /></STRONG></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/count-data/m-p/1152025#M906884 sagarrahul 2020-11-25T16:16:04Z Re: count data https://community.qlik.com/t5/QlikView/count-data/m-p/1152026#M906885 <HTML><HEAD></HEAD><BODY><P>Simply write:</P><P>count(CLM_XGEN_CLAIM_NUM)</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/128488_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 20 Jun 2016 10:03:49 GMT https://community.qlik.com/t5/QlikView/count-data/m-p/1152026#M906885 varshavig12 2016-06-20T10:03:49Z Re: count data https://community.qlik.com/t5/QlikView/count-data/m-p/1152027#M906886 <HTML><HEAD></HEAD><BODY><P>Here you go:</P><P><IMG __jive_id="128490" alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/128490_Screenshot_1.jpg" style="height: 94px; width: 620px;" /></P><P></P><P>Count function is used.</P><P></P><P>Take a look to the file attached.</P></BODY></HTML> Mon, 20 Jun 2016 10:10:22 GMT https://community.qlik.com/t5/QlikView/count-data/m-p/1152027#M906886 MindaugasBacius 2016-06-20T10:10:22Z Re: count data https://community.qlik.com/t5/QlikView/count-data/m-p/1152028#M906887 <HTML><HEAD></HEAD><BODY><P>Hi Sagar,</P><P>Try this,</P><P><STRONG>Count(DISTINCT <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CLM_XGEN_CLAIM_NUM</SPAN>)</STRONG></P></BODY></HTML> Mon, 20 Jun 2016 10:15:58 GMT https://community.qlik.com/t5/QlikView/count-data/m-p/1152028#M906887 susovan 2016-06-20T10:15:58Z