Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Unable to understand Peek function

Can someone please explain how peek function is working in the following example.


Unable to understand how peek function works in an internal table.

Thanks in advance.

Labels (2)
1 Reply
Partner Ambassador
Partner Ambassador

In your example the number for the peek field represents the 2nd parameter that was used.

The number is 0-based--the first record (Record 1) is 0. So,

0 is the first record in the table.
1 is the second..
2 is the third..
and so on.

For the first record, there were no records, so all fields are null.
For the second record, there was one record, so Peek(...,0) is the first record.



I hope this helps.