Remove empty and NA from filters

[Xclipse]

Hello @Samiksha

In Amazon QuickSight, you can filter out NA and empty strings by applying filters to your dataset or analysis. Here’s how you can do it:

Dataset Level

1. Go to your dataset:

• Open Amazon QuickSight and navigate to the dataset you are using.

2. Create a calculated field to filter out NA and empty strings:

• Click on Add and select Add Calculated Field.

• Create a calculated field to replace NA and empty strings with a value you want to exclude. For example: ifelse({your_field} = ‘NA’ or {your_field} = ‘’, NULL, {your_field})

• Name this calculated field appropriately.

3. Apply filters in the analysis:

• In your analysis, use the calculated field instead of the original field.
• Add a filter on this new calculated field to exclude NULL values.

Analysis Level

1. Open your analysis:

• Go to the analysis where you want to apply the filter.

2. Add a filter:

• Click on Filter in the pane on the left side.
• Select the field you want to filter.

3. Configure the filter:

• In the filter options, set the condition to exclude NA and empty strings. For example:
  • For NA:
    • Condition: is not equal to
    • Value: NA
  • For empty strings:
    • Condition: is not equal to
    • Value: ‘’
• Apply the filter.

By following these steps, you can effectively filter out NA and empty strings from your dataset or analysis in Amazon QuickSight.

Remove NULL and "empty string" from filter control values?

I have a dropdown filter control for selecting a country. The first two options are NULL and Empty string. I only want Select All and individual countries to be visible options. How to do this?