Peek function in the script - how flexible is it?

[jblomqvist]

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.

[swuehl]

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.

[ecolomer]

See this:

Missing Manual - Peek()

Peek till not null

[marcus_sommer]

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

- Marcus