Discussion Board for collaboration on QlikView Scripting.
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.
If(RecNo()=1, Amount,If(Product=Peek(Product), Value + Peek(AboveTotal),Value)) as AboveTotal
I never knew this was possible with peek.
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.
Missing Manual - Peek()
Peek till not null
A very good description could you find here: Peek() or Previous() ?