Search function gone in List Boxes

[#1]

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)

[sunny_talwar]

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

[antoniotiman]

Hi,

Try to add DISTINCT in Aggr() Function.

Regards

[Muthu]

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

[tresesco · Accepted solution]

Goto General tab->Default Search Mode ->Wildcard

Or, use like *NO* while searching.

[#6]

The Wildcard Search function worked perfectly! 🙂