topic Searching a List Box in QlikView

Searching a List Box

richard_chilvers — Thu, 20 Oct 2011 10:24:40 GMT

I have a list box which uses a calculated field. The data is listed perfectly, but the search function doesn't work - it never returns any values. I'm guessing this is because its a calculated field, but is there a way to make this work?

Thanks for any help.

Richard

Searching a List Box

Thu, 20 Oct 2011 10:39:13 GMT

Richard,

Are you saying that a search in the list box returns no matches in it or that it doesnt reconcile to a selection in the base data?

Could you provide an example?

What version are you using?

Regards,

Gordon

Re: Searching a List Box

Thu, 20 Oct 2011 10:56:40 GMT

Hi , from your question i understand that search function is not working when placing the Expression in Listbox.

If that is the question , try below step.

Goto the Listbox Properties --> General

You can try the "Use Wildcard Search" in Default Search Mode.

I hope this will helpful to you.

Regards

Venkat

Searching a List Box

richard_chilvers — Thu, 20 Oct 2011 11:02:24 GMT

Hi Venkat

Yes, that works. Are you able to tell me why the 'normal' default search method does not work ?

Regards

Richard

Searching a List Box

richard_chilvers — Thu, 20 Oct 2011 11:06:30 GMT

Hi Gordon

Thanks for taking the time to reply.

I am using version 10 and the search in my list box is returning no matches. My expression is:

=IF(MIXMATCH(number, '1','6','7')> 0, option)

You will see that I have now had a helpful answer which works for me, but I'd be interested to know why I had the problem.

Regards

Re: Searching a List Box

Thu, 20 Oct 2011 11:10:51 GMT

Hi ,

Sorry, i don't know exact reason behind this.

But only WildSearch works when we are using expression in listbox.

Regards

Venkat.

Re: Searching a List Box

Miguel_Angel_Baeyens — Thu, 20 Oct 2011 11:25:21 GMT

Hi Richard,

The "Normal Search" only looks for exact matches, hence it doesn't add any wildcards. If you want to look for a range or something you will need to add manually the wildcards (or the expression). The "Wildcard Search" does that exactly. And you can change that to work any time you use that search in the Settings menu, Document Properties, Presentation tab, and selecting the field and the search type.

Or change it in the Settings menu, User Preferences, General tab, so every document you develop has that shearc type by default instead.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Searching a List Box

richard_chilvers — Thu, 20 Oct 2011 13:14:59 GMT

Hi Miguel

My list box shows the values correctly, but even if I enter an exact match into the search field, no results will show. That doesn't seem correct.

Regards

Richard