topic Re: last updates from the table only in QlikView

last updates from the table only

0li5a3a — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need to dislay always the last updates from an excel files. Please find the files attached,

scenario :

•Take the latest timestamp data for the month e.g. 28th March

•Exclude any data with in blank from Development

I tried already the max and firstsortedvalue but I can't display only the last updates.

Can someone advice me?

I want to display only this

sunny_talwar — Tue, 27 Mar 2018 11:22:24 GMT

Try this

Table:

LOAD Development,

LGP,

NGPF,

G5b,

G5F,

BRNG,

FCS,

STD,

FVB,

OR,

Comment,

Timestamp

FROM

[Test Data.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Development > 0;

Right Join (Table)

LOAD Development,

Max(Timestamp) as Timestamp

Resident Table

Group By Development;

0li5a3a — Tue, 27 Mar 2018 11:32:19 GMT

Thanks for help, all good using your solution:)