Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jblomqvist
Contributor II

Peek function in the script - how flexible is it?

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.

3 Replies
MVP
MVP

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

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
Honored Contributor II

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

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

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

- Marcus

Community Browser