show previous and next 2 numbers

[Anonymous]

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.

Please find the attached file

[Anonymous]

how to select previous or next?

[#3]

Hi,

see the attacched.

Hope this helps

MC

[Anonymous]

No, It should show my value like I highlighted above.

Thanks any way.

[ecolomer]

Is this?

[Anonymous]

No, from my list ID for example I select ID 760820.

In the table I see only previous and next 2 numbers from my list ID.

In example I used this set analysis

only({<ID={'760591','760593','760820','760971','760979'}>}Text)

But I need the same principle, but dynamic

I don't have any ideas how to define previous and next number.

[Anonymous]

see attached....granted there is an extra step to click on a button. i did not have time to extend this to remove the button altogether. possible way this can be achieved is using triggers. when ID is selected, instead of clicking a button, may be you can add the same functionality in the trigger...good luck.

[Anonymous]

Please find the attached the file.

Instead of ID list, I should select any comment from CleanedText_Comment -> it shows me a history for this person (red font my selected number).

I just want to show previous and next 2 steps from my selected comment (red font in the table)

I use a trigger to select the history for comment CleanedText_Comment onChange and onSelect

select in field SessionId =vSID

where vSID==IF(GetSelectedCount(CleanedText_Comment)=1, SessionId,null())

I used Load * Rowno(). Since they are out of order for 1 sessionID, select in field row, I need to modify somehow just for selected session.

In the chart I used this condition

{<CleanedText_Comment= ,SessionId={'$(vSID)'}>}

Thank you,

[Anonymous]

Maybe it's possible to find by time (TimeStamp variable)

[preminqlik · Accepted solution]

hi there, find the attachment,