Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, Please find attached word document , I hope this will help you
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)
Hi, Please find attached word document , I hope this will help you
Thanks, this is awesome.
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
Hi, you first select orderID and then you are using the buttons previous next
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
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)
Again, thank you very much.