Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

function like "Peek" to get the next record

Hi guys,

I'm working on a report which requires me to get both the previous and the next record for every record in the output table. Now, I do asc/peek and desc/peek in two queries, but it takes a long time because it's a big output. Is there a way to use peek and something else like peek to get the next record in just one query?

Thanks in advance!

Labels (4)
1 Reply
Creator II
Creator II

Please share a sample Data set and share the desired output.