topic Re: How to fix problems with Peek in the script? in QlikView

How to fix problems with Peek in the script?

Tue, 05 Aug 2014 14:53:36 GMT

Hi, I'm trying to use the peek function in the script. Basically I have one value in the first month and I want to populate this down.

The issue peek function is having some aleatory issue and I cannot have this visible down.

The expression is the following =

if(isnull(DataPrice), Peek (DataPrice), DataPrice) as PricePeek,

ordered by Date

Please see below the expected results:

The files with the script are enclosed.

Thanks in advance, Leadro

giakoum — Tue, 05 Aug 2014 14:56:47 GMT

try

if(isnull(DataPrice), Peek (PricePeek), DataPrice) as PricePeek,

DavidFoster1 — Tue, 05 Aug 2014 15:04:38 GMT

Peek does not work that way. You might look at Previous.

My suggestion is that what you do is:

Tue, 05 Aug 2014 15:13:10 GMT

As suggested by Ioannis.

m_woolf — Tue, 05 Aug 2014 15:17:08 GMT

peek expects the field name to be a string.

Try:

peek('DataPrice')

Also peek will return null on the first record.

DavidFoster1 — Tue, 05 Aug 2014 15:19:55 GMT

Isn't the price wrong for Supplier A?

Tue, 05 Aug 2014 15:30:53 GMT

For supplier A per logic 2000 gets applied where ever there is a null. not sure what the desired output should be though.