topic Re: Most recent record by date in QlikView

Most recent record by date

rams007 — Wed, 07 Jun 2023 08:17:06 GMT

I Have data like below

changed_by	updated_at
1	2021-04-23T13:24:49.362Z
1	2021-04-23T13:26:13.601Z
2	2021-02-19T14:48:38.857Z
2	2021-03-10T09:28:41.247Z
2	2021-03-10T09:48:19.995Z
3	2022-05-30T06:49:19.206Z
3	2022-09-20T13:19:30.601Z

I need the resulting table to look like this

changed_by	updated_at
1	2021-04-23T13:26:13.601Z
2	2021-03-10T09:48:19.995Z
3	2022-09-20T13:19:30.601Z

Re: Most recent record by date

a_mullick — Wed, 07 Jun 2023 10:35:51 GMT

Hi,

You can use a MAX() function in a chart to pick out the latest timestap:

Re: Most recent record by date

Kushal_Chawda — Wed, 07 Jun 2023 10:36:19 GMT

@rams007 try below

Data: Load changed_by, timestamp(Timestamp#(updated_at,'YYYY-MM-DDThh:mm:ss.fffZ')) as updated_at FROM Source; Inner Join(Data) Load changed_by, timestamp(max(updated_at)) as updated_at Resident Data Group by changed_by;