Hi team I have an analysis in which I wanna filter a specific value in a column. I add a control to connect with the filter. I understand that with 1000+ values it won’t show up in dropdown, but also I cannot search with the control - the “Search” button did not show up after I input the value. Pressing “Enter” does not respond, thus I cannot filter data using this control. I’ve fixed this once by recreating the controls, but this problem comes up again.
I have attached a screenshot for this and wanna understand why is that.
This is a dropdown - multiselect control used in a sheet, and across different datasets. I got drop down list from one of the datasets (which should include all other datasets’ values of this column), although later the distinct values were too many to show the dropdown.
Hi Duncan, thanks for replying! I did connect it to a dataset field.
The process is like this:
I choose “Insert-Add parameter”, put in parameter name and choose “string” as type, leave default value as blank, then click “Create”.
On the next page I choose to also create a control, input the control name, choose “Dropdown - multiselect” as style, then “Link to a dataset field” and choose my dataset and column. It worked at the beginning, but after a while it won’t show me dropdown list, nor the Search button, as shown above. Thus this control become useless as I cannot choose (also I cannot input) a value with it.
This has happened twice. One possible reason I can guess, is that I’m using this control on different dataset, and it messed up. However, all datasets I use this control on should have the same set of values for dropdown list - and I was expecting this control to always choose value from the 1st dataset I told it to extract value from at creation time.
