topic Re: value not getting in main table in QlikView

value not getting in main table

sagarrahul — Mon, 27 Jun 2016 05:27:44 GMT

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_NAME

HOSPITAL_CODE

Clm_Type

ICD_CODE_LEVEL1_org

ICD Code Blacklist

total count of claims

Value

status

Max_date

clm_no

Current_date

Differnce

clm_num

4S CARE HOSPITAL

HEGIC-NN-71593

REIMBURSMENT

R57.2

0.000

Not Outlier

11-Feb-2016

RR-HS15-10336940

27/06/2016

138

4S CARE HOSPITAL

HEGIC-NN-71593

REIMBURSMENT

0.000

Not Outlier

11-Feb-2016

RR-HS15-10336940

27/06/2016

138

A J HOSPITAL AND RESEARCH CENTRE

HEGIC-NN-28935

REIMBURSMENT

0.000

Not Outlier

14-Mar-2016

RR-HS15-10341978

27/06/2016

106

A N N HOSPITAL

HEGIC-HS-04465

REIMBURSMENT

N18.9

0.000

Not Outlier

09-Mar-2016

RR-HS15-10341246

27/06/2016

111

A N N HOSPITAL

HEGIC-HS-04465

REIMBURSMENT

0.000

Not Outlier

09-Mar-2016

RR-HS15-10341246

27/06/2016

111

A ONE HOSPITAL PVT LTD

HEGIC-HS-01905

REIMBURSMENT

K85.9

0.000

Not Outlier

28-Apr-2016

RR-HC16-10349105

27/06/2016

A ONE HOSPITAL PVT LTD

HEGIC-HS-01905

REIMBURSMENT

0.000

Not Outlier

28-Apr-2016

RR-HC16-10349105

27/06/2016

A TUNGEKAR HOSPITAL

HEGIC-NN-75296

REIMBURSMENT

0.000

Not Outlier

14-May-2016

RR-HS16-10351758

27/06/2016

A. N. N. HOSPITAL

HEGIC-NN-71509

REIMBURSMENT

N85.2

0.000

Not Outlier

09-Feb-2016

RR-HS15-10336696

27/06/2016

140

A. N. N. HOSPITAL

HEGIC-NN-71509

REIMBURSMENT

0.000

Not Outlier

09-Feb-2016

RR-HS15-10336696

27/06/2016

140

HOSPITAL_NAME

HOSPITAL_CODE

Clm_Type

ICD_CODE_LEVEL1_org

ICD Code Blacklist

total count of claims

Value

status

Max_date

clm_no

Current_date

Differnce

clm_num

4S CARE HOSPITAL

HEGIC-NN-71593

REIMBURSMENT

R57.2

1.000

Outlier

11-Feb-2016

RR-HS15-10336940

27/06/2016

138

4S CARE HOSPITAL

HEGIC-NN-71593

REIMBURSMENT

0.000

Not Outlier

11-Feb-2016

RR-HS15-10336940

27/06/2016

138

Total

1.000

Outlier

11-Feb-2016

RR-HS15-10336940

27/06/2016

138

HOSPITAL_NAME

HOSPITAL_CODE

Clm_Type

ICD_CODE_LEVEL1_org

ICD Code Blacklist

total count of claims

Value

status

Max_date

clm_no

Current_date

Differnce

clm_num

A N N HOSPITAL

HEGIC-HS-04465

REIMBURSMENT

N18.9

1.000

Outlier

09-Mar-2016

RR-HS15-10341246

27/06/2016

111

A N N HOSPITAL

HEGIC-HS-04465

REIMBURSMENT

0.000

Not Outlier

09-Mar-2016

RR-HS15-10341246

27/06/2016

111

Total

1.000

Outlier

09-Mar-2016

RR-HS15-10341246

27/06/2016

111

Re: value not getting in main table

PrashantSangle — Mon, 27 Jun 2016 05:34:46 GMT

Hi,

what is your expression for value and status??

Regards

Re: value not getting in main table

sagarrahul — Mon, 27 Jun 2016 05:49:42 GMT

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

PrashantSangle — Mon, 27 Jun 2016 06:03:37 GMT

Hi,

try with aggr() for value expression.

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

Regards

Re: value not getting in main table

sagarrahul — Mon, 27 Jun 2016 06:12:40 GMT

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

Re: value not getting in main table

PrashantSangle — Mon, 27 Jun 2016 09:07:49 GMT

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

sagarrahul — Tue, 28 Jun 2016 05:00:22 GMT

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

before using ur expression :

HOSPITAL_NAME

HOSPITAL_CODE

Clm_Type

ICD_CODE_LEVEL1_org

ICD Code Blacklist

total count of claims

Value

status

Max_date

clm_no

Current_date

Differnce

clm_num

AADHAR HEALTH INSTITUTE

HEGIC-NN-66220

REIMBURSMENT

R50.9

0.500

Not Outlier

24-Feb-2016

RR-HS15-10339087

28/06/2016

126

AADHAR HEALTH INSTITUTE

HEGIC-NN-66220

REIMBURSMENT

S52.9

0.500

Not Outlier

29-Jan-2016

RR-HS15-10335006

28/06/2016

152

AADHAR HEALTH INSTITUTE

HEGIC-NN-66220

REIMBURSMENT

0.000

Not Outlier

24-Feb-2016

RR-HS15-10339087

28/06/2016

126

AADHAR HEALTH INSTITUTE

HEGIC-NN-66220

REIMBURSMENT

Total

1.000

Outlier

24-Feb-2016

RR-HS15-10339087

28/06/2016

126

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

after using ur expression :

HOSPITAL_NAME

HOSPITAL_CODE

Clm_Type

ICD_CODE_LEVEL1_org

ICD Code Blacklist

total count of claims

Value

status

Max_date

clm_no

Current_date

Differnce

clm_num

AADHAR HEALTH INSTITUTE

HEGIC-NN-66220

REIMBURSMENT

R50.9

0.000

Not Outlier

24-Feb-2016

RR-HS15-10339087

28/06/2016

126

AADHAR HEALTH INSTITUTE

HEGIC-NN-66220

REIMBURSMENT

S52.9

0.000

Not Outlier

29-Jan-2016

RR-HS15-10335006

28/06/2016

152

AADHAR HEALTH INSTITUTE

HEGIC-NN-66220

REIMBURSMENT

0.000

Not Outlier

24-Feb-2016

RR-HS15-10339087

28/06/2016

126

AADHAR HEALTH INSTITUTE

HEGIC-NN-66220

REIMBURSMENT

Total

0.000

Not Outlier

24-Feb-2016

RR-HS15-10339087

28/06/2016

126

and main table is as it was

HOSPITAL_NAME

HOSPITAL_CODE

Clm_Type

ICD_CODE_LEVEL1_org

ICD Code Blacklist

total count of claims

Value

status

Max_date

clm_no

Current_date

Differnce

clm_num

4S CARE HOSPITAL

HEGIC-NN-71593

REIMBURSMENT

R57.2

0.000

Not Outlier

11-Feb-2016

RR-HS15-10336940

28/06/2016

139

4S CARE HOSPITAL

HEGIC-NN-71593

REIMBURSMENT

0.000

Not Outlier

11-Feb-2016

RR-HS15-10336940

28/06/2016

139

4S CARE HOSPITAL

HEGIC-NN-71593

REIMBURSMENT

Total

0.000

Not Outlier

11-Feb-2016

RR-HS15-10336940

28/06/2016

139

A J HOSPITAL AND RESEARCH CENTRE

HEGIC-NN-28935

REIMBURSMENT

0.000

Not Outlier

14-Mar-2016

RR-HS15-10341978

28/06/2016

107

A J HOSPITAL AND RESEARCH CENTRE

HEGIC-NN-28935

REIMBURSMENT

Total

0.000

Not Outlier

14-Mar-2016

RR-HS15-10341978

28/06/2016

107

A N N HOSPITAL

HEGIC-HS-04465

REIMBURSMENT

N18.9

0.000

Not Outlier

09-Mar-2016

RR-HS15-10341246

28/06/2016

112

A N N HOSPITAL

HEGIC-HS-04465

REIMBURSMENT

0.000

Not Outlier

09-Mar-2016

RR-HS15-10341246

28/06/2016

112

A N N HOSPITAL

HEGIC-HS-04465

REIMBURSMENT

Total

0.000

Not Outlier

09-Mar-2016

RR-HS15-10341246

28/06/2016

112

A ONE HOSPITAL PVT LTD

HEGIC-HS-01905

REIMBURSMENT

K85.9

0.000

Not Outlier

28-Apr-2016

RR-HC16-10349105

28/06/2016

A ONE HOSPITAL PVT LTD

HEGIC-HS-01905

REIMBURSMENT

0.000

Not Outlier

28-Apr-2016

RR-HC16-10349105

28/06/2016

A ONE HOSPITAL PVT LTD

HEGIC-HS-01905

REIMBURSMENT

Total

0.000

Not Outlier

28-Apr-2016

RR-HC16-10349105

28/06/2016

A TUNGEKAR HOSPITAL

HEGIC-NN-75296

REIMBURSMENT

0.000

Not Outlier

14-May-2016

RR-HS16-10351758

28/06/2016

A TUNGEKAR HOSPITAL

HEGIC-NN-75296

REIMBURSMENT

Total

0.000

Not Outlier

14-May-2016

RR-HS16-10351758

28/06/2016

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

its urgent .

Re: value not getting in main table

maniram23 — Tue, 28 Jun 2016 06:12:38 GMT

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

sagarrahul — Tue, 28 Jun 2016 06:33:28 GMT

mani its showing all zero now

sorry its not working

Re: value not getting in main table

qliksus — Wed, 29 Jun 2016 02:30:02 GMT

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

sagarrahul — Wed, 29 Jun 2016 05:42:32 GMT

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_NAME	HOSPITAL_CODE	Clm_Type	ICD_CODE_LEVEL1_org	ICD Code Blacklist	total count of claims	Value	status
4S CARE HOSPITAL	HEGIC-NN-71593	REIMBURSMENT	R57.2	1	1	-	Not Outlier
4S CARE HOSPITAL	HEGIC-NN-71593	REIMBURSMENT	-	0	1	-	Not Outlier
4S CARE HOSPITAL	HEGIC-NN-71593	REIMBURSMENT	Total	1	1	-	Not Outlier
A J HOSPITAL AND RESEARCH CENTRE	HEGIC-NN-28935	REIMBURSMENT	-	0	1	-	Not Outlier
A J HOSPITAL AND RESEARCH CENTRE	HEGIC-NN-28935	REIMBURSMENT	Total	0	1	-	Not Outlier
A N N HOSPITAL	HEGIC-HS-04465	REIMBURSMENT	N18.9	1	1	-	Not Outlier
A N N HOSPITAL	HEGIC-HS-04465	REIMBURSMENT	-	0	1	-	Not Outlier
A N N HOSPITAL	HEGIC-HS-04465	REIMBURSMENT	Total	1	1	-	Not Outlier
A ONE HOSPITAL PVT LTD	HEGIC-HS-01905	REIMBURSMENT	K85.9	1	1	-	Not Outlier
A ONE HOSPITAL PVT LTD	HEGIC-HS-01905	REIMBURSMENT	-	0	1	-	Not Outlier
A ONE HOSPITAL PVT LTD	HEGIC-HS-01905	REIMBURSMENT	Total	1	1	-	Not Outlier
A TUNGEKAR HOSPITAL	HEGIC-NN-75296	REIMBURSMENT	-	0	1	-	Not Outlier
A TUNGEKAR HOSPITAL	HEGIC-NN-75296	REIMBURSMENT	Total	0	1	-	Not Outlier
A. N. N. HOSPITAL	HEGIC-NN-71509	REIMBURSMENT	N85.2	1	1	-	Not Outlier
A. N. N. HOSPITAL	HEGIC-NN-71509	REIMBURSMENT	-	0	1	-	Not Outlier
A. N. N. HOSPITAL	HEGIC-NN-71509	REIMBURSMENT	Total	1	1	-	Not Outlier

Re: value not getting in main table

Anil_Babu_Samineni — Wed, 29 Jun 2016 06:33:50 GMT

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

sagarrahul — Wed, 29 Jun 2016 06:35:46 GMT

this is my main table only where its showing null value

Re: value not getting in main table

qliksus — Thu, 30 Jun 2016 02:33:17 GMT

Its working for me

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

Re: value not getting in main table

Digvijay_Singh — Thu, 30 Jun 2016 03:44:59 GMT

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

sagarrahul — Mon, 04 Jul 2016 05:00:04 GMT

sry for late reply

yes [ICD Code Blacklist] its in wildmatch

Re: value not getting in main table

sagarrahul — Mon, 04 Jul 2016 09:42:25 GMT

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 .