double data

[sagarrahul]

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

1

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

1

0.000

Not Outlier

20-01-2016

RR-HS15-10333683

01/08/2016

195

-

ASHISH HALLAN

100169

CURE WELL HOSPITAL

Total

REIMBURSMENT

1

1

1.000

Outlier

20-01-2016

-

01/08/2016

195

-

[Anil_Babu_Samineni]

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

[PrashantSangle]

Hi,

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

try without it.

Regards

[sagarrahul]

stil its not coming

[jonathandienst]

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

[sagarrahul]

yes but how to bring clm_no in it

[sagarrahul]

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

[Anil_Babu_Samineni]

Why not this

Max(CLM_INTIMATION_DATE) & Max(CLM_XGEN_CLAIM_NUM)

[jonathandienst]

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