Missing Dropdown Values

thecbliss — Thu, 04 Apr 2024 17:59:35 GMT

I have a Writeback table with a dropdown column using defined options on a field. But when I go to search for certain values, it cannot find them. However I can see those values in a table using the field that defined the drop down options.

~~1st edit~~

~~Can someone please confirm if it is true that you can only have 10,000 searchable options in a writeback dropdown?~~

~~I had to use the wayback machine to follow the link in Qlik~~

~~Vizlib Help Centre | Vizlib Writeback Table - Input Field Options (archive.org)~~

2nd Edit

It appears that the only fields available to the dropdown are those fields in the scroll window. If I change how options are sorted, what's locatable by searching changes.

Re: Missing Dropdown Values

thecbliss — Fri, 05 Apr 2024 16:19:27 GMT

To solve this I created a filter pane and set the writeback table columns to get the appropriate selected value where options file was set to "getFieldValue(filtered_field#)" and then the add row button got the expression "if(getpossiblecount(filtered_field1)= 1 and getpossiblecount(filtered_field2)=1 and getpossiblecount(filtered_field3),1,0)" so that the button wasn't available until the fields were filtered. One the button is visible and clicked, it autopopulated the fields to the selected filtered field values.

topic Re: Missing Dropdown Values in App Development

Missing Dropdown Values

Re: Missing Dropdown Values