Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sai_katare
Contributor III
Contributor III

Unable to understand Peek function

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

sai_katare_0-1591912031889.png

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

Thanks in advance.

Labels (2)
1 Reply
lblumenfeld
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.

Etc.

 

I hope this helps.