Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarrahul
Creator
Creator

count data

want a help in this table

clm_xgen_claim_num is also showing one time as it should show 2 and

the yellow colour data is not getting count properly its showing only one time in blue but its should show 2 .

so how to do it

        

        

HOSPITAL_NAMEHOSPITAL_CODECLM_XGEN_CLAIM_NUMCLM_INTIMATION_DATEClm_TypeICD_CODE_LEVEL1_orgtotal count of claimsICD Code Blacklist
ADARSHA SPECIALITY HOSPITALHEGIC-HS-59905RR-HS15-1033380521-Jan-2016REIMBURSMENTO80.911
ADARSHA SPECIALITY HOSPITALHEGIC-HS-59905RR-HS15-1033380521-Jan-2016REIMBURSMENTO82.010
ADARSHA SPECIALITY HOSPITALTotal



11

3 Replies
varshavig12
Specialist
Specialist

Simply write:

count(CLM_XGEN_CLAIM_NUM)

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Here you go:

Screenshot_1.jpg

Count function is used.

Take a look to the file attached.

susovan
Partner - Specialist
Partner - Specialist

Hi Sagar,

Try this,

Count(DISTINCT CLM_XGEN_CLAIM_NUM)

Warm Regards,
Susovan