Max(date) in load script in where section

[aronvermeulen]

I want to make a table with only the latest 'Log date'.

a 'Document No' can contain multiple 'new status codes'.

But I want only to see the latest 'New Status Code'.

This is my script:

StatusLog1:

LOAD

[Document No_] as [Uitslag_No_],

[New Status Code],

[Log Date],

[Log Time]

FROM [lib://QVD (baslogistics_btb_qlik)/ProductieData\StatusLog1.qvd](qvd);

[neelamsaroha157 · Accepted solution]

May be you can use

StatusLog1:

LOAD

[Document No_] as [Uitslag_No_],

[New Status Code],

[Log Date],

[Log Time]

FROM [lib://QVD (baslogistics_btb_qlik)/ProductieData\StatusLog1.qvd](qvd);

inner join

Load [Uitslag_No_], max([Log Date]) as [Log Date]

resident StatusLog1

group by [Uitslag_No_]

;