Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sagarrahul
Creator
Creator
‎2016-06-21 02:15 AM

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 !!!!!!

1,314 Views
17 Replies
Anonymous
Not applicable
‎2016-06-21 02:26 AM

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.

826 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-06-21 02:32 AM
Author

In response to Anonymous

thank you manuel capella


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


can u guide me in this in detail

826 Views
0 Likes
Anonymous
Not applicable
‎2016-06-21 02:37 AM

In response to sagarrahul

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!!

826 Views
0 Likes
brijeshvma
Partner - Creator
Partner - Creator
‎2016-06-21 02:37 AM

In response to sagarrahul

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

826 Views
sagarrahul
Creator
Creator
‎2016-06-21 02:52 AM
Author

In response to sagarrahul

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

826 Views
0 Likes
Anonymous
Not applicable
‎2016-06-21 02:54 AM

In response to sagarrahul

Hi Sagar:

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


Regards!!

826 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-06-21 02:59 AM
Author

In response to Anonymous

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
826 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-06-21 03:01 AM
Author

In response to sagarrahul

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

826 Views
0 Likes
Anonymous
Not applicable
‎2016-06-21 03:10 AM

In response to sagarrahul

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!

826 Views
0 Likes