NULL value in Multi-value Parameter

Question & Answer
,
1

Hello Team,

I’m trying to define a multi-value String parameter that includes the NULL value in its default values like the screenshot below.

image
image663×810 31 KB

However, when I use this parameter as a filter, the records that are NULL are not selected, instead it tries to filter for records with the literal string ‘NULL’.

The article below says that NULL in parameters is supported but doesn’t provide an example on how it is done.

Am I doing this incorrectly or is having NULL as a default value not supported for Multi-value parameters?

Thanks in advance!

2

Hi raul_23,

Parameter control will give you an option to select null value if exist. If your goal is to set null as default for your dashboard, then I would recommend selecting null option in the control and then publishing your analysis as dashboard. It will set the NULL as a default for your dashboard

1 Like