Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

To find First and last recort of any table

Dear All,

How i can find first and last record of any table?

Will Peek(Field, 0 ) will work?

1 Solution

Accepted Solutions
Anonymous
Not applicable

first record

peek('Field',0,'Table') will get the first

peek('Field',-1,'Table') will find the last reord

'Table' is optional

View solution in original post

1 Reply
Anonymous
Not applicable

first record

peek('Field',0,'Table') will get the first

peek('Field',-1,'Table') will find the last reord

'Table' is optional