topic Max(date) in load script in where section in QlikView

Max(date) in load script in where section

aronvermeulen — Wed, 25 Nov 2020 16:16:04 GMT

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);

Re: Max(date) in load script in where section

neelamsaroha157 — Tue, 14 Aug 2018 16:02:45 GMT

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_]

;