Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

show previous and next 2 numbers

I have a list of ID. I want to select one randomly ID

and in a table show me only 2 previous, my selected and next 2 numbers.

Capture.PNG

Please find the attached file

11 Replies
Anonymous
Not applicable
Author

Thank you,

It's exactly what I need. but the problem is not all Id go sequence.

I need to group them by variable SessionId.

Please find my attached file.

It works so

From "Comments" chart, you select any comment, in "with + and - 2 ID"chart shown only 5 steps.

Sometimes it's less than 5 steps, sometimes is more. To compare I created the chart "All".

Anonymous
Not applicable
Author

I added only order by

Thanks,