Need Help with Filter Restrictions in QuickSight

Question & Answer
, , , ,
1

Hi Team,

How can we implement logic that restricts the current filter unless the previous filter is selected?

For example, we have two filters: one for Education Qualification and another for Job Type. I want to restrict users so that they must select the Education Qualification first before they can select the Job Type.

2

Hi @Biswajit_1993 ,

You can achieve this by using parameters and cascading filters.

step 1: Create parameter for education qualification with default value set as “< None>”.
step 2: Create parameter for job type
step 3: Add controls for both parameter. Enable show relevant values only for the second parameter.

Use the parameters in filter as needed.

Quick Callout : Since the value is set as < none> no data will be loaded until the user selects at least one value. Unless this is a multiselect parameter, disable select all options as well.

Thanks,
Prantika

2 Likes
3

Hi @prantika_sinha ,

Thank you for the detailed explanation. I will check and get back to you with the results.

Thanks & Regards
Biswajit Dash

4

Hi @Biswajit_1993,
It’s been awhile since we last heard from you, did you have any additional questions regarding your topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

5

Hi @Biswajit_1993,
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!