Cross reference one parameter with another

Question & Answer
, ,
7

Hi @jtroxel, thank you for your feedback. It seems the issue might be related to how the filter is set up in QuickSight. Let’s try a different approach with the filter settings to ensure it correctly excludes null values and only shows the data related to the ID passed via the URL parameter.

Step 1: Check Your Calculated Field Ensure your calculated field (Matched_Name) is set up correctly as follows:

Matched_Name = ifelse({ID_Number} = ${url_parameter}, {Name}, null)

This field should correctly return the Name when the ID_Number matches the URL parameter, and null otherwise.

Step 2: Adjust the Filter Setup Instead of using a “Custom filter,” which doesn’t allow you to exclude nulls directly, try setting up your filter as a “Filter list” or “Custom filter list.” Here’s how you can do it:

  1. Create a New Filter using the Matched_Name field.
  2. Select “Filter list” as the filter type if you want users to see and select from a list of available names.
  3. Alternatively, use “Custom filter list” if you want to programmatically control what appears in the list without user input.
  4. Set the filter condition to “is not null” to ensure that null values are excluded. This will prevent the dashboard from showing the “No data” message when the ID_Number from the URL does not match any entry in the dataset.

Step 3: Apply and Test the Filter Apply the new filter setting and test the dashboard by embedding it again with a specific ID_Number in the URL. Check if the dashboard now displays the data for the corresponding Name without showing “No data.”

Example URL:

https://your-region.quicksight.aws.amazon.com/sn/embedded/dashboards/12345678-1234-1234-1234-123456789012?ID_Number=specificID

Replace your-region, the dashboard ID, and specificID with the actual values.

On a side note, check out this QuickSight Embedded Analytics Developer Portal which contains code examples.

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing this specific problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena

2 Likes