Pass a variable to filter results from a data island

Wed, 27 Apr 2016 21:15:13 GMT

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

Re: Pass a variable to filter results from a data island

Nicole-Smith — Wed, 27 Apr 2016 21:39:18 GMT

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.

Re: Pass a variable to filter results from a data island

Fri, 20 May 2016 21:55:50 GMT

That works, Nicole!

Thanks for the assistance!

topic Re: Pass a variable to filter results from a data island in QlikView

Pass a variable to filter results from a data island

Re: Pass a variable to filter results from a data island

Re: Pass a variable to filter results from a data island