
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Peek function
Hi, my peek function is not working. It is showing as blank.
Not sure what's wrong.
Thanks
Jo
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, the issue was the EmpNo field was actually not a number it was text. Once i converted to number, it worked. Thank you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Jogo,
Can you please share what exactly output you are expecting
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Peek() without specifying the third parameter relates to the loaded table and there is no EmpNo as field because you renamed it to en and therefore you couldn't get any output. This means you may include EmpNo within this load or querying en instead within the peek() or you may switch to previous(EmpNo).
In your example it may be not important but within the most scenarios in which you need to use such interrecord-functions you need also to add an appropriate sorting with an order by statement to ensure that the load-order is like you expect it.
- Marcus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, the issue was the EmpNo field was actually not a number it was text. Once i converted to number, it worked. Thank you.
