Cascading Numeric Filters

Question & Answer
1

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

2

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 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:

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.Preformatted text

3

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

1 Like