16 Replies Latest reply: Jul 4, 2016 5:42 AM by sagar rahul RSS

    value not getting in main table

    sagar rahul

      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-
          -
        • Re: value not getting in main table
          Prashant Sangle

          Hi,

           

          what is your expression for value and status??

           

          Regards

            • Re: value not getting in main table
              sagar rahul

              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
                  Prashant Sangle

                  Hi,

                   

                  try with aggr() for value expression.

                   

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

                   

                  Regards

                    • Re: value not getting in main table
                      sagar rahul

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

                        • Re: value not getting in main table
                          Prashant Sangle

                          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

                            • Re: value not getting in main table
                              sagar rahul

                              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 .

                    • Re: value not getting in main table
                      mani ram

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

                        • Re: value not getting in main table
                          sagar rahul

                          mani its showing all zero now

                          sorry its not working

                            • Re: value not getting in main table
                              susant Kumar swain

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

                                • Re: value not getting in main table
                                  sagar rahul

                                  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
                            • Re: value not getting in main table
                              Anil Babu Samineni

                              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

                                • Re: value not getting in main table
                                  sagar rahul

                                  this is my main table only where its showing null value

                                    • Re: value not getting in main table
                                      Digvijay Singh

                                      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.

                                        • Re: value not getting in main table
                                          sagar rahul

                                          sry for late reply

                                          yes [ICD Code Blacklist] its in wildmatch

                                            • Re: value not getting in main table
                                              sagar rahul

                                              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 .