topic Re: Strange Peek() behaviour in QlikView

Strange Peek() behaviour

juleshartley — Tue, 06 Feb 2018 13:35:06 GMT

Hi All,

Can anyone explain this!

I have a table loaded as below

MxDate

43008

42978

42916

If I put this field in a list box and sort by 'load order' and show frequency I only have single values in the order shown above.

I have lines in my scrips as below:

let vRepDate = Peek('MxDate', 0);

let vRepDatePrior= Peek('MxDate', 1);

This returns vRepDate = 43008 (correct)

but vRepDatePrior = 42916 !!

I don't understand....

Re: Strange Peek() behaviour

swuehl — Tue, 06 Feb 2018 13:42:06 GMT

I can't reproduce this behaviour with the Information provided.

LOAD * INLINE [
MxDate
43008
42978
42916
];

let vRepDate = Peek('MxDate', 0);
let vRepDatePrior= Peek('MxDate', 1);

How is your field MxDate created?

Re: Strange Peek() behaviour

juleshartley — Tue, 06 Feb 2018 13:55:22 GMT

I'm creating it as follows:

MxDate:

Load Distinct Num(Date) as MxDate Resident Performance order by date desc;

Re: Strange Peek() behaviour

swuehl — Tue, 06 Feb 2018 14:21:00 GMT

The DISTINCT qualifier can mix up your output table rows, so the resulting MxDate table is not sorted in descending order ( the order by clause is only affecting the Input table).

Have a look at the table view table preview to see what I am talking about.

Re: Strange Peek() behaviour

juleshartley — Tue, 06 Feb 2018 14:25:04 GMT

Ah yes, I forgot about that! Thanks.