topic Re: Search function gone in List Boxes in QlikView

Search function gone in List Boxes

Tue, 28 Jul 2015 10:13:56 GMT

Hi all,

I have a number of listboxes where the search functionality has disappeared. I know part of the reason for this, but not a solution. Say, for example, that I have a List Box called Country or Town or and it includes all 100 000 towns in the country. In order for this list box to be handle-able for the end-user, I have added an expression to the list box so that only the Towns where we have positive spend actually appear. How can I reduce the entries shown and keep my search functionality? Below I show an example list box with the expression used, and also show what it should be like.

A normal list box search function:

With the expression:

Added an expression here:

What the expression says:

=aggr(if(sum({1}#ActualNetSpend_NOK)>0,only({1}Country)),Country)

Re: Search function gone in List Boxes

sunny_talwar — Tue, 28 Jul 2015 10:33:15 GMT

I guess one way would be to create another field in the script where you take in only those rows of data where you have positive spend. This way you won't be using an expression and you will get back your search functionality back

HTH

Best,

Sunny

Re: Search function gone in List Boxes

antoniotiman — Tue, 28 Jul 2015 10:40:24 GMT

Hi,

Try to add DISTINCT in Aggr() Function.

Regards

Re: Search function gone in List Boxes

Muthu — Tue, 28 Jul 2015 10:43:09 GMT

Hi Espen,

Try giving * followed by the text which you wanted to search

Taking the above example.

give *no* you will get the answer.

Hope this helps

Re: Search function gone in List Boxes

tresB — Tue, 28 Jul 2015 10:48:19 GMT

Goto General tab->Default Search Mode ->Wildcard

Or, use like *NO* while searching.

Re: Search function gone in List Boxes

Tue, 28 Jul 2015 10:53:24 GMT

The Wildcard Search function worked perfectly! 🙂