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: 
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-27 01:27 AM

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-
    -
666 Views
0 Likes
16 Replies
PrashantSangle
MVP
MVP
‎2016-06-27 01:34 AM

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 🙂
263 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-06-27 01:49 AM
Author

In response to PrashantSangle

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')

263 Views
0 Likes
PrashantSangle
MVP
MVP
‎2016-06-27 02:03 AM

In response to sagarrahul

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 🙂
263 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-06-27 02:12 AM
Author

In response to PrashantSangle

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

263 Views
0 Likes
PrashantSangle
MVP
MVP
‎2016-06-27 05:07 AM

In response to sagarrahul

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 🙂
263 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-06-28 01:00 AM
Author

In response to PrashantSangle

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 .

263 Views
0 Likes
maniram23
Creator II
Creator II
‎2016-06-28 02:12 AM

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

263 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-06-28 02:33 AM
Author

In response to maniram23

mani its showing all zero now

sorry its not working

263 Views
0 Likes
qliksus
Specialist II
Specialist II
‎2016-06-28 10:30 PM

In response to sagarrahul

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

263 Views
0 Likes