Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sagarrahul
New Contributor III

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

Re: value not getting in main table

Hi,

what is your expression for value and status??

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
sagarrahul
New Contributor III

Re: value not getting in main table

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

Re: value not getting in main table

Hi,

try with aggr() for value expression.

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
sagarrahul
New Contributor III

Re: value not getting in main table

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

Re: value not getting in main table

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.
sagarrahul
New Contributor III

Re: value not getting in main table

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
Contributor II

Re: value not getting in main table

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
New Contributor III

Re: value not getting in main table

mani its showing all zero now

sorry its not working

qliksus
Valued Contributor

Re: value not getting in main table

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

Community Browser