Pass a variable to filter results from a data island

[#1]

Hi Qlik Community!

I have an obstacle I’m hoping someone can help me overcome…

Scenario:

I have a .qvw with 2 tabs.

• The first tab displays orders along with order details.  The user enters an order number in the Search Object before the data is displayed. 

  • I have created a variable (vOrderNumber) that gets updated with the order number the user enters in the aforementioned Search Object.

• The second tab contains a table box with information from a data island (no association to the order tables).  The field titled MESSAGE in the data island contains the order number along with additional logging information.  See attached screenshot.

Problem/Question:   How do I pass the vOrderNumber variable to the table box so that the MESSAGE field only displays records that contain that order number?

I’d appreciate any assistance/suggestions.

Thanks!

Scott

[Nicole-Smith · Accepted solution]

You can set a trigger "OnActivateSheet" for Sheet 2 to select the order number in the message field.

I've attached a sample file that does this.

[#3]

That works, Nicole!

Thanks for the assistance!