Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
harson
Contributor III
Contributor III

Data in the max DateTime

Hello community,

I have a hang on QlikView.

I have as data this:

I would like to retrieve the lines with which the DateTime for each File_ID is the max of DateTime (marked in yellow)

Representing them in a table like this:

Thanks in advance for your help

Parts of Data :

LOAD * INLINE [

    Agents, File_ID, DateTime, Status

    John DOE, 622, 13/06/2018 16:29, 70

    John DOE, 622, 13/06/2018 12:48, 70

    John DOE, 622, 14/06/2018 12:29, 70

    John DOE, 622, 15/06/2018 10:27, 71

    John DOE, 633, 16/06/2018 07:29, 65

    John DOE, 633, 12/06/2018 08:26, 65

    John DOE, 611, 11/06/2018 12:25, 85

    Arold FAA, 611, 11/06/2018 12:39, 93

    John DOE, 352, 10/06/2018 12:35, 95

    John DOE, 352, 10/06/2018 12:45, 58

    Arold FAA, 633, 11/06/2018 09:07, 65

    John DOE, 352, 15/06/2018 12:48,

    John DOE, 352, 10/06/2018 12:36, 63

    John DOE, 611, 11/06/2018 12:52, 63

    John DOE, 611, 11/06/2018 12:23, 65

    Arold FAA, 633, 16/06/2018 12:29, 70

];

0 Replies