Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarrahul
Creator
Creator

value not getting in main table

hii good morning community

i am having problem in my two same table

in my whole table "value" are not be shown

but when i am  click it to my individual hospital its showing me the data as i want

so how can bring the value into main table also

         

HOSPITAL_NAMEHOSPITAL_CODEClm_TypeICD_CODE_LEVEL1_orgICD Code Blacklisttotal count of claimsValuestatusMax_dateclm_noCurrent_dateDiffernceclm_num
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENTR57.2110.000Not Outlier11-Feb-2016RR-HS15-1033694027/06/2016138-
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENT-010.000Not Outlier11-Feb-2016RR-HS15-1033694027/06/2016138-
A J HOSPITAL AND RESEARCH CENTREHEGIC-NN-28935REIMBURSMENT-010.000Not Outlier14-Mar-2016RR-HS15-1034197827/06/2016106-
A N N HOSPITALHEGIC-HS-04465REIMBURSMENTN18.9110.000Not Outlier09-Mar-2016RR-HS15-1034124627/06/2016111-
A N N HOSPITALHEGIC-HS-04465REIMBURSMENT-010.000Not Outlier09-Mar-2016RR-HS15-1034124627/06/2016111-
A ONE HOSPITAL PVT LTDHEGIC-HS-01905REIMBURSMENTK85.9110.000Not Outlier28-Apr-2016RR-HC16-1034910527/06/201661-
A ONE HOSPITAL PVT LTDHEGIC-HS-01905REIMBURSMENT-010.000Not Outlier28-Apr-2016RR-HC16-1034910527/06/201661-
A TUNGEKAR HOSPITALHEGIC-NN-75296REIMBURSMENT-010.000Not Outlier14-May-2016RR-HS16-1035175827/06/201645-
A. N. N. HOSPITALHEGIC-NN-71509REIMBURSMENTN85.2110.000Not Outlier09-Feb-2016RR-HS15-1033669627/06/2016140-
A. N. N. HOSPITALHEGIC-NN-71509REIMBURSMENT-010.000Not Outlier09-Feb-2016RR-HS15-1033669627/06/2016140-
HOSPITAL_NAMEHOSPITAL_CODEClm_TypeICD_CODE_LEVEL1_orgICD Code Blacklisttotal count of claimsValuestatusMax_dateclm_noCurrent_dateDiffernceclm_num
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENTR57.2111.000Outlier11-Feb-2016RR-HS15-1033694027/06/2016138-
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENT-010.000Not Outlier11-Feb-2016RR-HS15-1033694027/06/2016138-
Total


111.000Outlier11-Feb-2016RR-HS15-1033694027/06/2016138-
HOSPITAL_NAMEHOSPITAL_CODEClm_TypeICD_CODE_LEVEL1_orgICD Code Blacklisttotal count of claimsValuestatusMax_dateclm_noCurrent_dateDiffernceclm_num
A N N HOSPITALHEGIC-HS-04465REIMBURSMENTN18.9111.000Outlier09-Mar-2016RR-HS15-1034124627/06/2016111-
A N N HOSPITALHEGIC-HS-04465REIMBURSMENT-010.000Not Outlier09-Mar-2016RR-HS15-1034124627/06/2016111-
Total


111.000Outlier09-Mar-2016RR-HS15-1034124627/06/2016111-
    -
16 Replies
PrashantSangle

Hi,

what is your expression for value and status??

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
sagarrahul
Creator
Creator
Author

value

[ICD Code Blacklist]

/

if(len(CLM_XGEN_CLAIM_NUM)<=16,

Count({<CLM_TYPE={'REIMBURSMENT','REIMBURSEMENT','REIMBERSMENT','REIMBERSHMENT','REIMBUSMENT','REIMBURSEMNET'}>}distinct TOTAL<CLM_XGEN_CLAIM_NUM> CLM_XGEN_CLAIM_NUM))

and for status is

=If(([Value]) >= 0.7, 'Outlier', 'Not Outlier')

PrashantSangle

Hi,

try with aggr() for value expression.

sum(aggr(YourValueExpress,dim1,dim2,dim3))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
sagarrahul
Creator
Creator
Author

in which i should add this ur  expression in value or in status

PrashantSangle

Hi,

for value

try like

sum(aggr(

[ICD Code Blacklist]

/

if(len(CLM_XGEN_CLAIM_NUM)<=16,

Count({<CLM_TYPE={'REIMBURSMENT','REIMBURSEMENT','REIMBERSMENT','REIMBERSHMENT','REIMBUSMENT','REIMBURSEMNET'}>}distinct TOTAL<CLM_XGEN_CLAIM_NUM> CLM_XGEN_CLAIM_NUM))

,HOSPITAL_NAME,HOSPITAL_CODE,CLM_TYPE,ICD_CODE,ICD_CODE_LEVEL1_ORG))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
sagarrahul
Creator
Creator
Author

sorry max for late reply but now values are coming 0 .

before using ur expression :

             

HOSPITAL_NAMEHOSPITAL_CODEClm_TypeICD_CODE_LEVEL1_orgICD Code Blacklisttotal count of claimsValuestatusMax_dateclm_noCurrent_dateDiffernceclm_num
AADHAR HEALTH INSTITUTEHEGIC-NN-66220REIMBURSMENTR50.9110.500Not Outlier24-Feb-2016RR-HS15-1033908728/06/2016126-
AADHAR HEALTH INSTITUTEHEGIC-NN-66220REIMBURSMENTS52.9110.500Not Outlier29-Jan-2016RR-HS15-1033500628/06/2016152-
AADHAR HEALTH INSTITUTEHEGIC-NN-66220REIMBURSMENT-020.000Not Outlier24-Feb-2016RR-HS15-1033908728/06/2016126-
AADHAR HEALTH INSTITUTEHEGIC-NN-66220REIMBURSMENTTotal221.000Outlier24-Feb-2016RR-HS15-1033908728/06/2016126-

.....................................................................................

after using ur expression :

             

HOSPITAL_NAMEHOSPITAL_CODEClm_TypeICD_CODE_LEVEL1_orgICD Code Blacklisttotal count of claimsValuestatusMax_dateclm_noCurrent_dateDiffernceclm_num
AADHAR HEALTH INSTITUTEHEGIC-NN-66220REIMBURSMENTR50.9110.000Not Outlier24-Feb-2016RR-HS15-1033908728/06/2016126-
AADHAR HEALTH INSTITUTEHEGIC-NN-66220REIMBURSMENTS52.9110.000Not Outlier29-Jan-2016RR-HS15-1033500628/06/2016152-
AADHAR HEALTH INSTITUTEHEGIC-NN-66220REIMBURSMENT-020.000Not Outlier24-Feb-2016RR-HS15-1033908728/06/2016126-
AADHAR HEALTH INSTITUTEHEGIC-NN-66220REIMBURSMENTTotal220.000Not Outlier24-Feb-2016RR-HS15-1033908728/06/2016126-

and main table is as it was

             

HOSPITAL_NAMEHOSPITAL_CODEClm_TypeICD_CODE_LEVEL1_orgICD Code Blacklisttotal count of claimsValuestatusMax_dateclm_noCurrent_dateDiffernceclm_num
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENTR57.2110.000Not Outlier11-Feb-2016RR-HS15-1033694028/06/2016139-
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENT-010.000Not Outlier11-Feb-2016RR-HS15-1033694028/06/2016139-
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENTTotal110.000Not Outlier11-Feb-2016RR-HS15-1033694028/06/2016139-
A J HOSPITAL AND RESEARCH CENTREHEGIC-NN-28935REIMBURSMENT-010.000Not Outlier14-Mar-2016RR-HS15-1034197828/06/2016107-
A J HOSPITAL AND RESEARCH CENTREHEGIC-NN-28935REIMBURSMENTTotal010.000Not Outlier14-Mar-2016RR-HS15-1034197828/06/2016107-
A N N HOSPITALHEGIC-HS-04465REIMBURSMENTN18.9110.000Not Outlier09-Mar-2016RR-HS15-1034124628/06/2016112-
A N N HOSPITALHEGIC-HS-04465REIMBURSMENT-010.000Not Outlier09-Mar-2016RR-HS15-1034124628/06/2016112-
A N N HOSPITALHEGIC-HS-04465REIMBURSMENTTotal110.000Not Outlier09-Mar-2016RR-HS15-1034124628/06/2016112-
A ONE HOSPITAL PVT LTDHEGIC-HS-01905REIMBURSMENTK85.9110.000Not Outlier28-Apr-2016RR-HC16-1034910528/06/201662-
A ONE HOSPITAL PVT LTDHEGIC-HS-01905REIMBURSMENT-010.000Not Outlier28-Apr-2016RR-HC16-1034910528/06/201662-
A ONE HOSPITAL PVT LTDHEGIC-HS-01905REIMBURSMENTTotal110.000Not Outlier28-Apr-2016RR-HC16-1034910528/06/201662-
A TUNGEKAR HOSPITALHEGIC-NN-75296REIMBURSMENT-010.000Not Outlier14-May-2016RR-HS16-1035175828/06/201646-
A TUNGEKAR HOSPITALHEGIC-NN-75296REIMBURSMENTTotal010.000Not Outlier14-May-2016RR-HS16-1035175828/06/201646-

now can u help me in this as soon as possible .

its urgent .

maniram23
Creator II
Creator II

Hi,

Try this one.

[ICD Code Blacklist]

/

if(len(CLM_XGEN_CLAIM_NUM)<=16,

Count({<CLM_TYPE={'REIMBURSMENT'},HOSPITAL_NAME=>}distinct TOTAL<CLM_XGEN_CLAIM_NUM> CLM_XGEN_CLAIM_NUM))

sagarrahul
Creator
Creator
Author

mani its showing all zero now

sorry its not working

qliksus
Specialist II
Specialist II

Try moving the condition inside the aggregation

[ICD Code Blacklist]

/

Count({<CLM_TYPE={'REIMBURSMENT'}, CLM_XGEN_CLAIM_NUM={"=len(CLM_XGEN_CLAIM_NUM)<=16"} > distinct TOTAL<CLM_XGEN_CLAIM_NUM> CLM_XGEN_CLAIM_NUM))