topic Re: Load ID by Max date in Script in QlikView

Load ID by Max date in Script

priya945 — Sat, 16 Nov 2024 18:17:50 GMT

Hi All,

Below might be a basic but not able to attain the output. Please help

Test:
LOAD * Inline [

ID, Date
1, 7/28/2020 11:26:51 PM
1, 7/27/2020 10:04:20 AM
1, -

2, 7/29/2020 10:03:21 AM

];

Output

Thanks

brijesh_fofadiy — Wed, 29 Jul 2020 06:46:36 GMT

Hi Priya,

Please use below expression to get your result :

Aggr(Date(Max(Date)),ID)

priya945 — Wed, 29 Jul 2020 07:05:20 GMT

Solution may be as below

NoConcatenate
Test1:
LOAD ID,
max(Date) as Date

Resident Test
Group By ID;

DROP Table Test;