Hi All, I would appreciate any help as I am very stuck on this. I want to set my dashboard up to support showing a list of values but than apply the actual filter on a different set of columns where all these first values match. The reason for this is so that I can show a customer human readable …

Hi @firzen23 and welcome to the Quick Sight community! So you mentioned something towards the bottom that you have 3 datasets; so when mentioning your 3 tables, do you mean you have 3 table visuals that you’re trying to setup filtering between or 3 datasets that you’d like to filter? One option th…

Hi Brett, I appreciate the swift reply. Just to clarify it is 3 datasets that I am attempting to filter between. I have attempted a parameter filter like that and used an action to filter all the datasets down and while it does work it creates a really poor user experience for my use case as ther…

Hi @firzen23 , So if you setup a parameter control for member id (since that is the ‘like’ field you have in all datasets), that should just bring up results for that specific member…Would you be able to share a screenshot of the navigation action you setup? If you want to limit the number of resul…

Hi Brett, I understand I can setup a control on member_id the issue is that the end users don’t know what these ID’s are as they are internal. What you are suggesting does in fact work just not a great user experience. Is there anyway I can put together a demo and share it with you to better expla…

Hi Brett, Apologies for the delay in getting back to this. I have included a sample visualization explaining what I want to do. MemberTest Essentially I want to have a Control that just has the member’s name information and I want the dataset to be filtered even though they do not have that fiel…

Hi @firzen23 , Thanks for the additional context! Unfortunately, Quick Sight does not have the capability to recognize field values from one dataset within another based on a different matching field though. I don’t really see a work around for this scenario that does not involve adding the member …

Did you considered dataset parameter? not sure if it helps in your use case The dataset still needs to join across multiple tables (include the table with member name). Advantage is the performance will be faster as data will be filtered when user choose member name. But the query still need to joi…

Hi @firzen23 , It’s been a while since we last heard from you, did you have any additional questions regarding your initial post? If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic. Thank you!

Hi @firzen23 , Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed. Thank you!

How to have a control with a set of values but apply the filter on a different column

Q&A

Brett October 10, 2024, 9:37pm 6

Hi @firzen23,
Understood, and of course…you can upload a copy of your analysis (with sample data or removal of confidential information) through the Quick Sight Arena view. Here’s a walkthrough on how to utilize if you never have!

Topic		Replies	Views
Filtering visuals created with different datasets Q&A filters , quick-sight , Business-Intelligence-Engineer	3	145	March 16, 2024
How to aply only one filter to the same dashboard that has more than one dataset applied to it? Q&A filters , quick-sight , Business-Intelligence-Engineer	1	28	September 10, 2025
Create filter for a visual from one dataset that only shows the relevant values based off of a filter from another dataset Q&A filters , quick-sight , filters-controls-and-parameters	1	394	February 15, 2023
Use a filter control for one field, but implement the actual filter on a different field Q&A quick-sight , dataset , Business-Intelligence-Engineer , tables	8	243	December 27, 2023
AWS Quick Sight connect 2 parameters with different values Q&A data-source , analysis , filters , parameters , quick-sight , visuals , dashboard , dataset , filters-controls-and-parameters , Business-Intelligence-Engineer	3	535	April 2, 2024

How to have a control with a set of values but apply the filter on a different column

Related topics