Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hii good morning to all
i am having a problem in this
this is my code
"=if(len(CLM_XGEN_CLAIM_NUM)<=16,Count({<CLM_LEVEL_OF_CARE={'Secondary'}>}distinct CLM_XGEN_CLAIM_NUM))"
this is my column below
CLM_XGEN_CLAIM_NUM |
RC-HS15-10319322-1 |
RR-HS15-10340556 |
in this i dnt want the supplementary 'CLM_XGEN_CLAIM_NUM' coun i want only main count only
as given below
EG :
RC-HS15-10319322-1 |
RR-HS15-10340556 |
so count should be 1 as main claim is RR-HS15-10340556
can anyone help me in this
Hi,
try like
=if(len(CLM_XGEN_CLAIM_NUM)<=16 and len(KeepChar(CLM_XGEN_CLAIM_NUM,'-'))=2,Count({<CLM_LEVEL_OF_CARE={'Secondary'}>}distinct CLM_XGEN_CLAIM_NUM))
Regards
Try like:
Count({<CLM_XGEN_CLAIM_NUM={"=len(CLM_XGEN_CLAIM_NUM)<=16"}, CLM_LEVEL_OF_CARE={'Secondary'}>}distinct CLM_XGEN_CLAIM_NUM)
ty max
this is my table
CLM_XGEN_CLAIM_NUM | CLM_INTIMATION_DATE | CLM_LEVEL_OF_CARE | ICD_CODE_LEVEL1_org | Claim_Type | ICD Code Blacklist | total count of claims |
RC-HS15-10318402-1 | 22-Jan-2016 | Secondary | J34.2 | - | 1 | - |
RC-HS15-10318402-2 | 09-Feb-2016 | Secondary | J34.2 | - | 1 | - |
RC-HS16-10352325 | 17-May-2016 | Secondary | K76.2 | - | 1 | 1 |
- | 3 | - |
as there are 3 claims but i want only main claim in my total count of claims column that is 1
but its not showing its total in yellow column .
can u help me in this
Did you try the expression I suggested above? So you want all three rows to be displayed, but the count to work or one, right? Could you post your sample qvw?
ur expression is showing error
Hi,
tresesco solution is correct just missed to closed " in set analysis.
Count({<CLM_XGEN_CLAIM_NUM={"=len(CLM_XGEN_CLAIM_NUM)<=16"}, CLM_LEVEL_OF_CARE={'Secondary'}>}distinct CLM_XGEN_CLAIM_NUM)
try that solution.
Regards,
i want this output
CLM_XGEN_CLAIM_NUM | CLM_INTIMATION_DATE | CLM_LEVEL_OF_CARE | ICD_CODE_LEVEL1_org | Claim_Type | ICD Code Blacklist | total count of claims | Value | status |
RC-HS15-10318402-1 | 22-Jan-2016 | Secondary | J34.2 | - | 1 | - | 0.000 | Outlier |
RC-HS15-10318402-2 | 09-Feb-2016 | Secondary | J34.2 | - | 1 | - | 0.000 | Outlier |
RC-HS16-10352325 | 17-May-2016 | Secondary | K76.2 | - | 1 | 1 | 1.000 | Outlier |
- | 3 | 1 | 1.000 | Outlier |
Thanks max. Good catch. Corrected now.