Remove null from control paramter dropdown

Question & Answer
, , ,
1

Hi all,

Is there a method to exclude the null in the dropdown menu of a control paramter filter?
image

I can’t filter the data in my dataset to exclude the null as this is a cross-join, hence it will cause other data to be missing.

Thanks.

2

Hi @dixerio,

When you create your control, you can select the “Specific values” option and enter the values that you want to be selectable instead of linking it to a field.

image
image607×689 26.9 KB

3

Hi @David_Wong ,

If I do this, then I can’t use this filter in my visualisation (which are linked to this field).

4

@dixerio

I have a dataset contains 3 different regions: AMER, APJ and EMEA.
image

My control contains only AMER and APJ because I entered specific values for it instead of linking it to the Region field of my dataset.
image

image

You should be able to use the same idea to remove the null value from your control.

Can you share a screenshot showing how your filter and control were created?

5

Hi @David_Wong ,

Thanks for following up.

I can’t use multi-select dropdown if I go with this method, correct? Cos it appears to be grey out for me.

6

Hi @dixerio,

You can use a multi-select dropdown.
image

image
image442×557 16.7 KB

Where do you see it greyed out? Can you share a screenshot?

7

Hey @David_Wong

Seems like I got it to work. Probably I had brain fart trying to make both the control and filter work properly. Thanks for your help.