topic Re: max date in QlikView

max date

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

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

Re: max date

avinashelite — Tue, 19 Jul 2016 05:50:34 GMT

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

Re: max date

sagarrahul — Tue, 19 Jul 2016 05:54:21 GMT

how i can add sample data

Re: max date

ramasaisaksoft — Tue, 19 Jul 2016 06:06:40 GMT

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

Re: max date

avinashelite — Tue, 19 Jul 2016 06:09:19 GMT

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

Re: max date

sagarrahul — Tue, 19 Jul 2016 06:12:46 GMT

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

Re: max date

sagarrahul — Tue, 19 Jul 2016 06:22:53 GMT

now can u help me in this

its my dump excel sheet

Re: max date

avinashelite — Tue, 19 Jul 2016 07:04:14 GMT

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;

Re: max date

sagarrahul — Tue, 19 Jul 2016 08:33:48 GMT

avinash ty for ur work but i want it expression

can u help me in this