Drop down multi select control - only shoes search text box

Question & Answer
, ,
1

Hi

I use drop down - multi select control to populate a parameter.
the control is fed from a specific field (field c1) within a dataset. The field have is nullable.
When I try to use the control within an analysis and then by a dashboard, I get a search textbox without any values originated from c1 field, though there are none-null values within this field.
I addition I removed any cascading controls related to this control.

Appriciate your advise.

Thanks!
Amihai

2

hi @amico ,
sometimes it could be that there are to many elements in the field and you only get a search box.
can you try to search for a element you know?
BG

3

Hi @ErikG ,

Basically, in c1 I have only one value x in 2 records out of 5000. all the rest are null values.

4

Hi @ErikG,

In another case I do have a lot of elements in the field and I get the search text box.
When trying to search a specific value I know exists in the field the feeds the control, I don’t get a result.

5

Looks like there is a filter what filters your field.

1 Like
6

Hi @ErikG,

Relating to the same issue of drop down multi select control-
Is there a way to show also an option of picking null values in the control?
For example, I want to filter all null values and aggregate the metric based on this value.

Thank you!

7

Hello @amico and @ErikG !

@amico are you still running into this problem or were you able to find a workaround? Also, if @ErikG 's solution was helpful, could you mark it as a solution?

For your second question, when creating your parameter control with the filter, you should be able to include Null as a value to filter by.

8

Hello @amico and @ErikG !

It has been some time since there has been activity on this question, but we would still like to help find a solution. Are you still running into this problem or were you able to resolve this, and if so could you share the solution to help the community?

If we do not hear from you in 3 days this topic will be archived.

9

HI @amico
regarding “null values” you could try to use a filter direct on the field
grafik
or create a new field “isNullValue” = ifelse(isNull(your_field),1,0) and use it as a filter.
BR

10

Hi @ErikG @duncan

I truly don’t remember :joy:
I think we can mark it as resolved by now.

Thank you both for your support!

2 Likes