Help needed on "How to find next/previous value of the field?"

[SebastianRichter]

Hello experts,

I'm referring to this post:

Solved: How to find next/previous value of the field? - Qlik Community - 831644

I'm not able to open the qvw file since I'm working in a company system.

I would really appreciate if anyone can give a short instruction with screenshots on which button i should use and which code i need to enter.

I have a list of order numbers through which i want to switch.

Thanks a lot.

Best regards,

Sebastian

[saso70 · Accepted solution]

Hi, Please find attached word document , I hope this will help you

[SebastianRichter]

Thanks, this is awesome.

[SebastianRichter]

Hi Saso70, 

one more question. Rows in the straight table in the left lower corner of your word file do not get filtered by the selection made with the "previous and next buttons" but are only highlighted green.

How to do that? When I use the buttons, my straight table only show the one row currently selected.

Thanks in advance.

Best regards,

Sebastian

[saso70]

Hi, you first select orderID and then you are using the buttons previous next

[SebastianRichter]

Hi, 

what I meant is the table in left lower corner, please see the screenshot below.

Even though you selected Order ID 10248 (red circle), you still have all other order IDs visible in the table (blue circle). It is just that order ID 10248 has a green background. I want the same in my table for better overview, but in my table all not selected Order IDs vanish and only order ID10248 remains in the table. 

So what do i need to set in the table in order to keep all Order IDs visible and only give the green background to the row I selected by the buttons.

Thanks for having patience with me.

Best regards,

Sebastian

[saso70 · Accepted solution]

In all your fields(all fields are from Fact table) in background color you need to add the expression:  if(OrderID = only({1} OrderID) and count(total distinct OrderID)=1,
green(), white())

OrderDate Field is calculated: only({<OrderID=>}OrderDate)

[SebastianRichter]

Again, thank you very much.