Filtre and parameters

Question & Answer
1

Hello! I have a filter that works by parameter, and other filters that work normally, choosing the field I need. What I see is that the filter to be parameterized, does not impact the other filters, how can I fix that?

2

Hi @Raulsc,
I understand that you would like to show only relevant values within one “filter” (assuming you are actually referring to controls in QuickSight) depending on the selection of the value in another filter? Please let me know if I misunderstood (screenshots of current and expected behavior could help).

To achieve this, you can leverage the “Show relevant values only” option in the control options of the control that you would like to adjust shown values based on another control (in your case the control that is linked to the parameter). Here is an example that links a product id control/filter with a product type control, which is linked to a parameter:

control_relevant_values_only
control_relevant_values_only1271×869 70.1 KB

If you would want to link it to a parameterized filter without showing a control, you can follow the instructions shared here.

I hope my solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking his answer as a “Solution”.

2 Likes
3

Hello, @Thomas @abacon , @Max , @Jesse Could you help me?
Let me explain better:

I have a parameterized ‘‘hidden’’ filter, which is filtered by url by adding a code to that parameter. and that filters all visuals on the sheet.

image

And also I have several controls that between them if the filters are applied, but does not apply the filtering of the parameter.

I mean, when I apply a filter at url level the visuals are filtered but in the controls appear all the fields, when they should appear only the fields filtered by that parameter.

image

4

Thanks @Raulsc for the explanation. To me it still sounds like the solution that I had linked above should solve your ask. Please check out this solution again. For the “Show relevant values only” option to work, you need to create a control for your hidden filter. However, you can hide it from the end users as described on the linked solution.

I hope my solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking his answer as a “Solution”.

5

hi @Thomas ,

image
Not work, because this filter use parameters…

6

Hi @Raulsc,
I just re-created the scenario once more from scratch.

  1. Created a parameter pProductType
  2. Created a filter that leverages that parameter to filter on product type
  3. Used the “Add control” option on the parameter to add a dropdown control, which I then moved to the sheet
  4. Added a second filter to filter based on product ID
  5. Used the “Add to sheet” option to add that filter to the sheet
  6. Linked the control with the “Product Type” control that has been created first and is linked to the parameter
  7. Used the Rules in the formatting options of the “Product Type” control to hide the control

As a result, as seen in the screenshot, the value to filter the product type can be passed to the dashboard via the URL, which then filters the visual as well as just shows the relevant values within the “Product ID” control:

parameterized_filter_control
parameterized_filter_control1700×738 66 KB

If these steps don’t work for you, can you please provide a detailed description of how you got into the situation that you observed, so that I can reproduce and provide additional guidance. Thanks in advance!

7

that definitely works! Thanks for the awesome help! I was adding the filter and that’s why it was giving error, you have to add the parameter !