Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Jogo
Partner - Contributor II
Partner - Contributor II

Peek function

Hi, my peek function is not working. It is showing as blank. 

Not sure what's wrong. 

 

Thanks

Jo

 

Labels (1)
1 Solution

Accepted Solutions
Jogo
Partner - Contributor II
Partner - Contributor II
Author

Hi, the issue was the EmpNo field was actually not a number it was text. Once i converted to number, it worked. Thank you.

View solution in original post

3 Replies
abhijitnalekar
Specialist II
Specialist II

Hi @Jogo,

Can you please share what exactly output you are expecting 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
marcus_sommer

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

Jogo
Partner - Contributor II
Partner - Contributor II
Author

Hi, the issue was the EmpNo field was actually not a number it was text. Once i converted to number, it worked. Thank you.