Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
Luminary Alumni
Luminary Alumni

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.