# Cascading Numeric Filters

**URL:** <https://community.amazonquick.com/t/cascading-numeric-filters/18073>\
**Category:** Q&A\
**Tags:** filters, quick-sight\
**Created:** [September 14, 2023, 9:00pm UTC](https://community.amazonquick.com/t/cascading-numeric-filters/18073 "2023-09-14T21:00:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jefft](https://avatars.discourse-cdn.com/v4/letter/j/e95f7d/32.png) [@jefft](https://community.amazonquick.com/u/jefft)\
**Post date:** [September 14, 2023, 9:00pm UTC](https://community.amazonquick.com/t/cascading-numeric-filters/18073/1 "2023-09-14T21:00:28Z")

</div>

Hi All,

I am trying to create cascading parameters/filters that does two things:

1. Users can ONLY enter relevant values into control 1 (i.e. 1, 2, or 3 and nothing else - I understand if text may be entered, there’s a red outline to display that entry isn’t appropriate)  
1.1 IF the user enters a value other than 1, 2, or 3 (per my example), are there error messages/other options to tell the user that the particular entry isn’t right?
2. Control 2 ONLY allows relevant inputs based on what control 1 stores.

For ex. if a user enters the value 3 into control 1, then control 2 can ONLY allow the user to enter a number above 20 (arbitrary value). If a user tried to enter 5 into control 2, they should receive an error message.

I hope the above makes sense. Any thoughts?

Thanks

---

<div class="post-metadata">

**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\
**Post date:** [September 15, 2023, 2:36pm UTC](https://community.amazonquick.com/t/cascading-numeric-filters/18073/2 "2023-09-15T14:36:00Z")

</div>

Hello @jefft !

To clarify, is the goal to keep certain users from accessing specific sensitive data by using the cascading filters? If the goal is data security, I would suggest adding [RLS](https://docs.aws.amazon.com/quicksight/latest/user/row-level-security.html) if you haven’t already to make sure users can only access the data they have permissions to.

What you could try is when you create the parameter, is set it to have multiple values and designate those values as 1, 2 and 3. Then for the target visual or table, create an `ifelse` statement that similar to this one:

```auto
ifelse(
${123Param} = '1', {Target_field} = 'target row key value', 
${123Param} = '2', {Target_field} = 'target row key value 2'
${123Param} = '3', {Target_field} = 'target row key value 3'
NULL)

```

For the custom error message, to my knowledge there are no baked in customization options in the UI, but you could try [this solution from another post that have a similar result](https://community.amazonquick.com/t/can-i-show-an-error-message-on-dashboard-when-user-enters-wrong-data-in-textfield-filter-in-the-controls/2224/3).Preformatted text

---

<div class="post-metadata">

**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\
**Post date:** [September 20, 2023, 2:52pm UTC](https://community.amazonquick.com/t/cascading-numeric-filters/18073/3 "2023-09-20T14:52:05Z")

</div>

Hello @jefft, did Duncan’s response help you resolve the issue you were facing in Quick Sight?