topic Re: double data in QlikView

double data

sagarrahul — Wed, 25 Nov 2020 16:16:04 GMT

this is my table

i want clm no to b printed but its not coming as it is coming double so can u help me in this

code used is below :

=FirstSortedValue(CLM_XGEN_CLAIM_NUM,-aggr(Max(if(len(KeepChar(CLM_XGEN_CLAIM_NUM,'-'))<>3,CLM_INTIMATION_DATE)),

POL_BDM_CODE,POL_BDM_NAME,HOSPITAL_CODE,HOSPITAL_NAME,CLM_INTIMATION_DATE,ICD_CODE_LEVEL1_org))

can u help me in this

POL_BDM_NAME

POL_BDM_CODE

HOSPITAL_NAME

HOSPITAL_CODE

CLM_LEVEL_OF_CARE

ICD_CODE_LEVEL1_org

Claim_Type

ICD Code Blacklist

total count of claims

Value

status

Max_date

clm_no

Current_date

Differnce

clm_num

ASHISH HALLAN

100169

CURE WELL HOSPITAL

HEGIC-HS-01055

Primary

A09.9

REIMBURSMENT

1.000

Outlier

20-01-2016

RR-HS15-10333683

01/08/2016

195

ASHISH HALLAN

100169

CURE WELL HOSPITAL

HEGIC-HS-01055

Primary

L08.9

REIMBURSMENT

0.000

Not Outlier

20-01-2016

RR-HS15-10333683

01/08/2016

195

ASHISH HALLAN

100169

CURE WELL HOSPITAL

Total

REIMBURSMENT

1.000

Outlier

20-01-2016

01/08/2016

195

Re: double data

Anil_Babu_Samineni — Mon, 01 Aug 2016 06:35:16 GMT

Can you please post sample aplication

I request you to please, Don't create one issue for two threads.

Try to close this Thread

Re: same date occurring for two time but can tress another value

Re: double data

PrashantSangle — Mon, 01 Aug 2016 07:15:22 GMT

Hi,

It is because you have added "ICD_CODE_LEVEL1_org" in aggr() expression

try without it.

Regards

Re: double data

sagarrahul — Mon, 01 Aug 2016 09:00:41 GMT

stil its not coming

Re: double data

jonathandienst — Mon, 01 Aug 2016 09:26:05 GMT

Its not double, you have multiple rows with different values of ICD_CODE_LEVEL1_org.

Re: double data

sagarrahul — Mon, 01 Aug 2016 09:31:27 GMT

yes but how to bring clm_no in it

Re: double data

sagarrahul — Mon, 01 Aug 2016 09:51:34 GMT

CLM_INTIMATION_DATE	CLM_XGEN_CLAIM_NUM
30-Dec-2015	RC-HS15-10330521
30-Dec-2015	RC-HS15-10330521
11-Jan-2016	RC-HS15-10332140
25-Oct-2015	RC-HS15-10306032-1
05-Apr-2016	RC-HS16-10345459
05-Apr-2016	RC-HS16-10345479

see i want max date ie (CLM_INTIMATION_DATE) and clm_no ie (CLM_XGEN_CLAIM_NUM)

but when it comes two same date then i want its max clm_no

output :

05-Apr-2016 RC-HS16-10345479

now can any1 help me in this

Re: double data

Anil_Babu_Samineni — Mon, 01 Aug 2016 10:01:36 GMT

Why not this

Max(CLM_INTIMATION_DATE) & Max(CLM_XGEN_CLAIM_NUM)

Re: double data

jonathandienst — Mon, 01 Aug 2016 12:19:50 GMT

>>but when it comes two same date then i want its max clm_no

For the tiny glimpse onto your data, the two clm_no values are identical.

i suggest that you post a small sample qvw with some representative data and a clear statement about what you are attempting to calculate and what your expected results.