Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarrahul
Creator
Creator

dividing single value with total

hii good morning need a help

this is my table

         

HOSPITAL_NAMEHOSPITAL_CODECLM_XGEN_CLAIM_NUMCLM_INTIMATION_DATEClm_TypeICD_CODE_LEVEL1_orgtotal count of claimsICD Code BlacklistValue
ADITYA HOSPITALSHEGIC-HS-23852RR-HS15-1033537201-Feb-2016REIMBURSMENTR50.9110.1000
ADITYA HOSPITALSHEGIC-HS-23852RR-HS15-1033537201-Feb-2016REIMBURSMENT-100.1000
ADITYA HOSPITALSHEGIC-HS-23852RR-HS15-1033608305-Feb-2016REIMBURSMENTS42.0110.1000
ADITYA HOSPITALSHEGIC-HS-23852RR-HS15-1033608305-Feb-2016REIMBURSMENT-100.1000
ADITYA HOSPITALSHEGIC-HS-23852RR-HS15-1033865322-Feb-2016REIMBURSMENTN39.0110.1000
ADITYA HOSPITALSHEGIC-HS-23852RR-HS15-1033865322-Feb-2016REIMBURSMENT-100.1000
ADITYA HOSPITALSTotal



330.3000


i want to divide ( individual ICD_CODE_LEVEL1_org /total count of claims )

eg :

R50.9/3

means 1/3=0.3333

i am getting a problem its dividing whole column as u can see i have mark it in yellow colour

so can any one help me in this !!!!!!

17 Replies
Anonymous
Not applicable

Hi Sagar:

Count(ICD_CODE_LEVEL1_org)/COUNT(TOTAL CLM_XGEN_CLAIM_NUM)


You have 1 claim by ICD_CODE_LEVEL, and 3 claims in total.


Change on chart properties, the number format of your expression.


Regards.

sagarrahul
Creator
Creator
Author

thank you manuel capella


Change on chart properties, the number format of your expression.


can u guide me in this in detail

Anonymous
Not applicable

Hi Sagar,

See that picture. On chart properties, search the number tab. Select your Expression and then, select Fixed to, and set all decimals do you wanna see.

Regards!!

brijeshvma
Partner - Creator
Partner - Creator

Hi Sagar,

if you want to show result in table ... then you can Write

Count(ICD_CODE_LEVEL1_org)/COUNT(TOTAL CLM_XGEN_CLAIM_NUM)


and if you want to divide by value then

Sum(ICD_CODE_LEVEL1_org)/COUNT(TOTAL CLM_XGEN_CLAIM_NUM)


if you share your sample data so able to show you

sagarrahul
Creator
Creator
Author

need one help

this is my table

         

HOSPITAL_NAMEHOSPITAL_CODECLM_XGEN_CLAIM_NUMCLM_INTIMATION_DATEClm_TypeICD_CODE_LEVEL1_orgtotal count of claimsICD Code BlacklistValue
SHRADDHA HOSPITALHEGIC-NN-16813RR-HS15-1034081905-Mar-2016REIMBURSMENTB54110.111
SHRADDHA HOSPITALHEGIC-NN-16813RR-HS15-1034081905-Mar-2016REIMBURSMENT-100.000
SHRADDHA HOSPITALHEGIC-NN-24044RR-HS15-1033710612-Feb-2016REIMBURSMENTJ33.9110.111
SHRADDHA HOSPITALHEGIC-NN-24044RR-HS15-1033710612-Feb-2016REIMBURSMENT-100.000
SHRADDHA HOSPITALHEGIC-NN-24044RR-HS16-1035140012-May-2016REIMBURSMENTR50.9110.111
SHRADDHA HOSPITALHEGIC-NN-24044RR-HS16-1035140012-May-2016REIMBURSMENT-100.000
SHRADDHA HOSPITALHEGIC-NN-47415RR-HS16-1035012904-May-2016REIMBURSMENTA98.8110.111
SHRADDHA HOSPITALHEGIC-NN-47415RR-HS16-1035012904-May-2016REIMBURSMENT-100.000
SHRADDHA HOSPITALHEGIC-NN-58389RR-HC16-1034542805-Apr-2016REIMBURSMENTA90110.111
SHRADDHA HOSPITALHEGIC-NN-58389RR-HC16-1034542805-Apr-2016REIMBURSMENT-100.000
SHRADDHA HOSPITALHEGIC-NN-58389RR-HS15-1034281418-Mar-2016REIMBURSMENTA79.9110.111
SHRADDHA HOSPITALHEGIC-NN-58389RR-HS15-1034281418-Mar-2016REIMBURSMENTR50.9110.111
SHRADDHA HOSPITALHEGIC-NN-58389RR-HS15-1034281418-Mar-2016REIMBURSMENT-100.000
SHRADDHA HOSPITALHEGIC-NN-58389RR-HS15-1034282718-Mar-2016REIMBURSMENTR50.9110.111
SHRADDHA HOSPITALHEGIC-NN-58389RR-HS15-1034282718-Mar-2016REIMBURSMENT-100.000
SHRADDHA HOSPITALHEGIC-NN-58389RR-HS15-1034363523-Mar-2016REIMBURSMENTA91110.111
SHRADDHA HOSPITALHEGIC-NN-58389RR-HS15-1034363523-Mar-2016REIMBURSMENT-100.000
SHRADDHA HOSPITALTotal



890.778

in this i have marked column ICD_CODE_LEVEL1_org in that there are certain data which is repeated so i want

there sum divided by TOTAL CLM_XGEN_CLAIM_NUM

eg :

R50.9 is respeated 3 times

so i want 3/8=0.375


can u help me in this also

Anonymous
Not applicable

Hi Sagar:

Count(DISTINCT ICD_CODE_LEVEL1_org)/COUNT(TOTAL DISTINCT CLM_XGEN_CLAIM_NUM)


Regards!!

sagarrahul
Creator
Creator
Author

see i am not getting what i want

        

HOSPITAL_NAMEHOSPITAL_CODECLM_XGEN_CLAIM_NUMCLM_INTIMATION_DATEClm_TypeICD_CODE_LEVEL1_orgtotal count of claimsICD Code Blacklist
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033092402-Jan-2016REIMBURSMENTR39.811
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033092402-Jan-2016REIMBURSMENTT80.911
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033092402-Jan-2016REIMBURSMENT-10
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033746014-Feb-2016REIMBURSMENTJ20.911
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033746014-Feb-2016REIMBURSMENT-10
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS16-1034943330-Apr-2016REIMBURSMENTI25.411
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS16-1034943330-Apr-2016REIMBURSMENT-10
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS16-1034943530-Apr-2016REIMBURSMENTI25.411
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS16-1034943530-Apr-2016REIMBURSMENT-10
ROCKLAND HOSPITAL LTDTotal



45
sagarrahul
Creator
Creator
Author

it is not getting full table will divide it

    

HOSPITAL_NAMEHOSPITAL_CODECLM_XGEN_CLAIM_NUMCLM_INTIMATION_DATE
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033092402-Jan-2016
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033092402-Jan-2016
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033092402-Jan-2016
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033746014-Feb-2016
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS15-1033746014-Feb-2016
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS16-1034943330-Apr-2016
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS16-1034943330-Apr-2016
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS16-1034943530-Apr-2016
ROCKLAND HOSPITAL LTDHEGIC-HS-14794RR-HS16-1034943530-Apr-2016
ROCKLAND HOSPITAL LTDTotal

    

Clm_TypeICD_CODE_LEVEL1_orgtotal count of claimsICD Code Blacklist
REIMBURSMENTR39.811
REIMBURSMENTT80.911
REIMBURSMENT-10
REIMBURSMENTJ20.911
REIMBURSMENT-10
REIMBURSMENTI25.411
REIMBURSMENT-10
REIMBURSMENTI25.411
REIMBURSMENT-10


45

now it is clear to u get it sorted

Anonymous
Not applicable

Count of ICD_CODE -> =Count(DISTINCT ICD_CODE_LEVEL1_org)

Count of CLAIM_NUM -> Count(DISTINCT CLM_XGEN_CLAIM_NUM)

Division -> Count(DISTINCT ICD_CODE_LEVEL1_org)/Count(DISTINCT CLM_XGEN_CLAIM_NUM)

Regards!