topic Re: I need Where Max CreateDate in QlikView

I need Where Max CreateDate

Sxbbb — Fri, 15 Nov 2024 21:48:25 GMT

I need Where Max Filed ' CreateDate'

Aditya_Chitale — Tue, 21 Feb 2023 05:50:29 GMT

MaxDate:
Load
max(CreateDate) as MaxCreateDate
From [xyz.qvd](qvd);

let vMaxCReateDate=peek('MaxCreateDate',0,'MaxDate');
Drop table MaxDate;

MainTable:
load
a,
b,
CreateDate,
d,
e
From [xyz.qvd](qvd) where CreateDate='$(vMaxCReateDate)';

Regards,

Aditya

Sxbbb — Tue, 21 Feb 2023 06:14:06 GMT

I tried but the data is not showing.

Aditya_Chitale — Tue, 21 Feb 2023 07:28:18 GMT

Check if the field date format is same as date format in variable.

If that doesn't work ,please share sample data ? You can jumble the numbers if you want.

Regards,

Aditya