Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Input Boxes - Searching and Limiting

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. 

2.png

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.

1.png

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

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

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

View solution in original post

8 Replies
Highlighted
Not applicable

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

Highlighted
Specialist
Specialist

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

Highlighted
Specialist
Specialist

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

View solution in original post

Highlighted
Specialist
Specialist

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

Highlighted
Specialist
Specialist

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.

Highlighted
Specialist
Specialist

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.

Highlighted
Not applicable

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

Highlighted
Specialist
Specialist

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