Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vovan4ik
Specialist II
Specialist II

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

1 Solution

Accepted Solutions
preminqlik
Specialist II
Specialist II

hi there, find the attachment,

View solution in original post

11 Replies
vovan4ik
Specialist II
Specialist II
Author

how to select previous or next?

Not applicable

Hi,

see the attacched.

Hope this helps

MC

vovan4ik
Specialist II
Specialist II
Author

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

Thanks any way.

ecolomer
Master II
Master II

Is this?

p01.png

vovan4ik
Specialist II
Specialist II
Author

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

Capture.PNG

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

jsaradhi
Specialist
Specialist

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.

vovan4ik
Specialist II
Specialist II
Author

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,

vovan4ik
Specialist II
Specialist II
Author

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

preminqlik
Specialist II
Specialist II

hi there, find the attachment,

View solution in original post