Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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