topic Re: show previous and next 2 numbers in QlikView

show previous and next 2 numbers

Anonymous — Tue, 16 Dec 2014 21:10:30 GMT

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

Re: show previous and next 2 numbers

Anonymous — Tue, 16 Dec 2014 21:27:54 GMT

how to select previous or next?

Re: show previous and next 2 numbers

Tue, 16 Dec 2014 21:44:57 GMT

Hi,

see the attacched.

Hope this helps

Re: show previous and next 2 numbers

Anonymous — Tue, 16 Dec 2014 21:49:28 GMT

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

Thanks any way.

Re: show previous and next 2 numbers

ecolomer — Tue, 16 Dec 2014 22:27:57 GMT

Is this?

Re: show previous and next 2 numbers

Anonymous — Wed, 17 Dec 2014 14:49:43 GMT

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.

Re: show previous and next 2 numbers

Anonymous — Wed, 17 Dec 2014 15:09:25 GMT

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.

Re: show previous and next 2 numbers

Anonymous — Wed, 17 Dec 2014 16:17:20 GMT

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,

Re: show previous and next 2 numbers

Anonymous — Wed, 17 Dec 2014 17:19:52 GMT

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

Re: show previous and next 2 numbers

preminqlik — Thu, 18 Dec 2014 00:46:01 GMT

hi there, find the attachment,

Re: show previous and next 2 numbers

Anonymous — Thu, 18 Dec 2014 17:07:08 GMT

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".

Re: show previous and next 2 numbers

Anonymous — Thu, 18 Dec 2014 18:20:12 GMT

I added only order by

Thanks,