Peek - script function

This script function returns the contents of the fieldname in the record specified by row in the internal table tablename. Data are fetched from the associative Qlik Sense database.

Syntax:

Peek(fieldname [ , row [ , tablename ] ] )

Arguments:

Argument	Description
Fieldname	Must be given as a string (e.g. a quoted literal).
Row	Must be an integer. 0 denotes the first record, 1 the second and so on. Negative numbers indicate order from the end of the table. -1 denotes the last record read. If no row is stated, -1 is assumed.
Tablename	A table label without the ending colon. If no tablename is stated, the current table is assumed. If used outside the LOAD statement or referring to another table, the tablename must be included.

Argument

Description

Fieldname

Must be given as a string (e.g. a quoted literal).

Row

Must be an integer. 0 denotes the first record, 1 the second and so on. Negative numbers indicate order from the end of the table. -1 denotes the last record read.

If no row is stated, -1 is assumed.

Tablename

A table label without the ending colon. If no tablename is stated, the current table is assumed. If used outside the LOAD statement or referring to another table, the tablename must be included.

Example	Result
Peek( 'Sales' )	Returns the value of Sales in the previous record read ( equivalent to Previous(Sales) ).
Peek( 'Sales', 2 )	Returns the value of Sales from the third record read from the current internal table.
Peek( 'Sales', -2 )	Returns the value of Sales from the second last record read into the current internal table.
Peek( 'Sales', 0, 'Tab1' )	Returns the value of Sales from the first record read into the input table labeled Tab1.
LOAD A, B, numsum( B, Peek( 'Bsum' ) ) as Bsum...;	Creates an accumulation of B in Bsum.

Learn more

Table labels

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here