Filtering out null values in parameters

Question & Answer
,
1

I have created a parameter for my report that pulls data from the backend.
There are a few null values in the backend that the parameter is picking up.
Is there a way I can filter out these null values in my parameter>

2

Hi @gopinathpc,
When setting up a parameter, QuickSight does not have a dedicated tool that helps filter out nulls, as they are designed more to list every value that’s available when mapped to a specific field.
There are a couple work arounds you could explore.

  1. Instead of utilizing a parameter for your control, setup a filter for the field in discussion and then create a control for that filter. When doing this, you can choose what values you’d like to include/exclude:

    image
    image469×760 49.1 KB

  2. Alternatively, If you need to have this control setup as a parameter for various reasons; you would need to define the specific values that you’d like available in your dropdown/parameter list:

    image
    image546×606 23.9 KB

This can be a rather tedious process though if you have a lot of value options for your field. One additional thing to keep in mind here, when filling in the ‘specific values’, this section is case sensitive so you’ll need to type the values in as they appear in the dataset so that you can still use the parameter for action items and filtering.

Let me know if you have any additional questions

3

Thanks for the workarounds. Since it needs to be a parameter, I have to go with option 2, though it may need more support if the values keep changing.