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
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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-
    -
671 Views
0 Likes
16 Replies
sagarrahul
Creator
Creator
‎2016-06-29 01:42 AM
Author

In response to qliksus

qliiksus its not working

after adding this

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

its showing this value in my table

and most imp its not showing value in my "value" field only

so look it into it

        

HOSPITAL_NAMEHOSPITAL_CODEClm_TypeICD_CODE_LEVEL1_orgICD Code Blacklisttotal count of claimsValuestatus
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENTR57.211-Not Outlier
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENT-01-Not Outlier
4S CARE HOSPITALHEGIC-NN-71593REIMBURSMENTTotal11-Not Outlier
A J HOSPITAL AND RESEARCH CENTREHEGIC-NN-28935REIMBURSMENT-01-Not Outlier
A J HOSPITAL AND RESEARCH CENTREHEGIC-NN-28935REIMBURSMENTTotal01-Not Outlier
A N N HOSPITALHEGIC-HS-04465REIMBURSMENTN18.911-Not Outlier
A N N HOSPITALHEGIC-HS-04465REIMBURSMENT-01-Not Outlier
A N N HOSPITALHEGIC-HS-04465REIMBURSMENTTotal11-Not Outlier
A ONE HOSPITAL PVT LTDHEGIC-HS-01905REIMBURSMENTK85.911-Not Outlier
A ONE HOSPITAL PVT LTDHEGIC-HS-01905REIMBURSMENT-01-Not Outlier
A ONE HOSPITAL PVT LTDHEGIC-HS-01905REIMBURSMENTTotal11-Not Outlier
A TUNGEKAR HOSPITALHEGIC-NN-75296REIMBURSMENT-01-Not Outlier
A TUNGEKAR HOSPITALHEGIC-NN-75296REIMBURSMENTTotal01-Not Outlier
A. N. N. HOSPITALHEGIC-NN-71509REIMBURSMENTN85.211-Not Outlier
A. N. N. HOSPITALHEGIC-NN-71509REIMBURSMENT-01-Not Outlier
A. N. N. HOSPITALHEGIC-NN-71509REIMBURSMENTTotal11-Not Outlier
174 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2016-06-29 02:33 AM

Sagar,

Is there any chance to share the Application? Without that how do we identify. in your main table, Value field showing all null values only..

- Anil

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
174 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-06-29 02:35 AM
Author

In response to Anil_Babu_Samineni

this is my main table only where its showing null value

174 Views
0 Likes
qliksus
Specialist II
Specialist II
‎2016-06-29 10:33 PM

In response to sagarrahul

Its working for me

Could be a syntax issue it would be great if you can attach a sample

174 Views
0 Likes
Digvijay_Singh
MVP
MVP
‎2016-06-29 11:44 PM

In response to sagarrahul

It looks like from your main table that

[ICD Code Blacklist] is not a dimension, if yes then What is the expression for  [ICD Code Blacklist], if you used it naked means without any aggregation, it may cause problems.

Also I was trying to create a sample but then realize that field CLM_XGEN_CLAIM_NUM is not available in the sample table you have attached, if we get sample data for that field, we should be able to create working sample.

Also just to confirm hope, CLM_TYPE is in upper case in your value formula but the heading shows it in lower case, just check in case caz QV field names are case sensitive.

174 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-07-04 01:00 AM
Author

In response to Digvijay_Singh

sry for late reply

yes [ICD Code Blacklist] its in wildmatch

174 Views
0 Likes
sagarrahul
Creator
Creator
‎2016-07-04 05:42 AM
Author

In response to sagarrahul

Digvijay Singh thank you for ur help

As u said

"ICD Code Blacklist"

"CLM_XGEN_CLAIM_NUM"

"CLM_TYPE"

are not taken in deminsion because it were causing problem in my table its

was doing bifurcationin my value and its were not coming in as i want my

ans so i have not taken it 

and "CLM_TYPE" in that there are various "REIMBURSMENT" in various

caps ie in upper and Lower case

i am having problem in my same table

in my whole table "value" are not be shown

but when i am clicking it to my individual hospital its showing me the data as i want as shown in my above table

so now can u help me in this .

174 Views
0 Likes