topic Re: Peek function returns the wrong Date in QlikView

Peek function returns the wrong Date

rustyfishbones — Mon, 15 Sep 2014 16:25:56 GMT

Hi All,

I have following table

Transaction:

LOAD

warehouse,

DATE([date-added],'DD/MM/YYYY') AS Date

FROM

(qvd);

LET vMaxDateTime = Peek('Date',-1,'Transaction');

However the variable is not returning the correct date

It should be returning 29/05/2014 but it keeps returning 26/09/2013

Any ideas?

m_woolf — Mon, 15 Sep 2014 16:50:46 GMT

What makes you think the it should be returning 29/05/2014?

Mon, 15 Sep 2014 16:54:32 GMT

Zero denotes first record of the table.

-1 denotes last record of the table

tresB — Mon, 15 Sep 2014 16:55:08 GMT

Were the dates sorted when stored in qvd? Are you looking for max date? If so, try like:

Load

Max([date added]) a Maxdate

From <>;

LET vMaxDateTime = Date(Peek('Date'));

m_woolf — Mon, 15 Sep 2014 17:02:12 GMT

Why don't you display the records sorted by load order to verify the contents of the last record?

marcus_sommer — Tue, 16 Sep 2014 01:05:43 GMT

- Marcus