topic Re: Input Boxes - Searching and Limiting in QlikView

Input Boxes - Searching and Limiting

Anonymous — Tue, 25 Mar 2014 21:17:34 GMT

Morning all

I have email forms with input boxes that contain drop down lists defined by =concat(DISTINCT{1}[Field Name], ',') so the drop down selection didn’t filter other input boxes.

This works great however I have noticed you can’t search them the same way you can search a multibox drop down i.e. by just starting to type.

Does anyone know of a way to make an input box drop down searchable in this manner.

Also if anyone knows how to make a input box mandatory that information would be greatly appreciated.

Bella

Re: Input Boxes - Searching and Limiting

Tue, 25 Mar 2014 23:28:26 GMT

Hi Bella

I see that's a multibox you've got there,am I right?

The setting in the multibox for the search style is not in an obvious place. Go to the properties, then the presentation tab. Highlight a field expression by clickingon it, then click the"advanced" button from the options on the right. The default search mode you are looking for is the wildcard search.

Does this work for you?

Erica

Re: Input Boxes - Searching and Limiting

Anonymous — Wed, 26 Mar 2014 00:16:29 GMT

Thanks Erica

Yes that is where the setting is in the multibox but it's the input box I need to change the setting on. I want the multibox style search on the input box.

Bella

Re: Input Boxes - Searching and Limiting

srchilukoori — Wed, 26 Mar 2014 01:28:16 GMT

The search option is not available for the drop down list of an Input box.

Re: Input Boxes - Searching and Limiting

Anonymous — Wed, 26 Mar 2014 01:42:04 GMT

Thanks, I was fairly sure that was the answer but thought someone elase may be able to prove me wrong.

Re: Input Boxes - Searching and Limiting

srchilukoori — Wed, 26 Mar 2014 01:45:16 GMT

If the drop down list is too long you can remove the {1} in the set expression, that way you can limit the no. of values.

Re: Input Boxes - Searching and Limiting

Anonymous — Wed, 26 Mar 2014 01:51:35 GMT

Unfortunately the full list, although long in some cases, needs to be there was just trying to avoid people having to scroll too much to find the selection they are after. Because it is a input email form the drop downs need to be independant of one another but some are very long.

Re: Input Boxes - Searching and Limiting

Wed, 26 Mar 2014 11:54:41 GMT

Hi Bella

If your input box options are limited you could "fake it" with a list box that links to a stand-alone field comprising the drop down items you wish to use. Then you could link your variable to the selection in that field. If you set the list box to "always one selected value" that will prevent users fromselecting more than one item.

Erica

Re: Input Boxes - Searching and Limiting

Anonymous — Wed, 26 Mar 2014 19:43:20 GMT

I can see the value in that but I do need the whole list there.