topic Peek function in the script - how flexible is it? in QlikView

Peek function in the script - how flexible is it?

jblomqvist — Mon, 25 Jan 2016 21:53:53 GMT

Hi,

Can anybody tell me how flexible is the script function in the script?

It seems to behave differently compared to some QlikView rules for fields.

For example if I create a calculated field, I can refer that field back into the same calculated field.

E.g.

Load

Product,

Value

If(RecNo()=1, Amount,If(Product=Peek(Product), Value + Peek(AboveTotal),Value)) as AboveTotal

Resident Table

I never knew this was possible with peek.

Re: Peek function in the script - how flexible is it?

swuehl — Mon, 25 Jan 2016 22:00:47 GMT

Essentially, Peek() is addressing fields in the ouput table records (vs. input table records that can be adressed by Previous() ), hence all fields that are the result of your table load can be used.

Re: Peek function in the script - how flexible is it?

ecolomer — Mon, 25 Jan 2016 22:21:26 GMT

See this:

Missing Manual - Peek()

Peek till not null

Re: Peek function in the script - how flexible is it?

marcus_sommer — Tue, 26 Jan 2016 06:48:59 GMT

A very good description could you find here: Peek() or Previous() ?

- Marcus