max date

[sagarrahul]

this is my table and my fields below

CLM_XGEN_CLAIM_NUM

CLM_LEVEL_OF_CARE

ICD_CODE_LEVEL1_org

Claim_Type

ICD Code Blacklist

large claims

Value

status

clm_no

Max_date

Current_date

Differnce

clm_num

in max date i want max date of latest claim num but it should be only of main claims not supplementary claim

and in ICD Code Blacklist i want count of main claims only of ICD_CODE_LEVEL1_org

output i want :

CLM_INTIMATION_DATE	CLM_XGEN_CLAIM_NUM	CLM_LEVEL_OF_CARE	ICD_CODE_LEVEL1_org	Claim_Type	ICD Code Blacklist	large claims	Value	status	clm_no	Max_date	Current_date	Differnce	clm_num
04-Jan-2016	RC-HS15-10325506-1	Secondary	J22	-	0	0	-	Not Outlier	-	04-Jan-2016	19/07/2016	-	-
30-Nov-2015	RC-HS15-10325506	Secondary	J22	-	1	1	1.000	Outlier	RC-HS15-10325506	30-Nov-2015	19/07/2016	-	-
24-Dec-2015	RC-HS15-10329647	Secondary	A01.0	-	1	1	1.000	Outlier	RC-HS15-10329647	24-Dec-2015	19/07/2016	-	-
06-Dec-2015	RC-HS15-10326507	Secondary	J22	-	1	1	1.000	Outlier	RC-HS15-10326507	06-Dec-2015	19/07/2016	-	-
26-Jan-2016	RC-HS15-10325506-2	Secondary	J22	-	0	0	-	Not Outlier	-	26-Jan-2016	19/07/2016	-	-
01-May-2016	RC-HS16-10349544	Secondary	N39.0	-	0	1	0.000	Not Outlier	RC-HS16-10349544	01-May-2016	19/07/2016	-	-
31-May-2016	RC-HS16-10349544-1	Secondary	N39.0	-	0	0	-	Not Outlier	-	31-May-2016	19/07/2016	-	-
				-	3	4	0.750	Outlier	RC-HS16-10349544	01-May-2016	19/07/2016	-	-

[avinashelite]

please share the sample data so that we can suggest the solution

[sagarrahul]

how i can add sample data

[ramasaisaksoft]

Hi  Sagar,

Top 1 in the list ,Click to reply to that

then one more pop will open

there top of the right hand side you can find Use Advanced Editor

Click on that then you can find Attach File,So click on that and attach your sample dummy data Excel sheet.

PFA..

[avinashelite]

you could directly type the sample data in the reply or add your data to a excel file ...Click on replay >Top right > Use advanced editor > Bottom left you could see the attachment option

[sagarrahul]

i not given full application of qlikview have just given an application  to use so

[sagarrahul]

now can u help me in this

its my dump excel sheet

[avinashelite]

I don't see a proper sample data ...try like this

Temp:

LOAD

LM_XGEN_CLAIM_NUM

CLM_LEVEL_OF_CARE

ICD_CODE_LEVEL1_org

Claim_Type

ICD Code Blacklist

large claims

Value

status

clm_no

Max_date

Current_date

Differnce

clm_num;

Result:

LOAD

clm_no

Max(date_field) as Max

resident

Temp

group by

clm_no;

[sagarrahul]

avinash ty for ur work but i want it expression

can u help me in this