Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarrahul
Creator
Creator

Double date

hiii

my table

Max_dateclm_no
20-05-2016RC-HS16-10352928
15-03-2016RC-HS15-10342240
13-04-2016RC-HS16-10346883
14-11-2015RC-HS15-10322714
26-04-2016RC-HS16-10348822
20-05-2016RC-HS16-10352928
20-05-2016RC-HS16-10352928
20-05-2016-

this is my code for getting clm_no :

=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,CLM_XGEN_CLAIM_NUM,ICD_CODE_LEVEL1_org))

in this second coulmn  last field is coming blank

in this i want max date with its clm_no but max_date is coming but clm_no is not coming

there are there 3 time same max_date and same  3 time same clm_no in this table


so i want this output in table :


  

Max_dateclm_no
20-05-2016RC-HS16-10352928
15-03-2016RC-HS15-10342240
13-04-2016RC-HS16-10346883
14-11-2015RC-HS15-10322714
26-04-2016RC-HS16-10348822
20-05-2016RC-HS16-10352928
20-05-2016RC-HS16-10352928
20-05-2016RC-HS16-10352928

so pls help me in this its on urgent basics

0 Replies