Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search function gone in List Boxes

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:

Capture.PNG

With the expression:

Capture.PNG

Added an expression here:

Capture.PNG

What the expression says:

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Goto General tab->Default Search Mode ->Wildcard

Or, use like *NO* while searching.

View solution in original post

5 Replies
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
Master III
Master III

Hi,

Try to add DISTINCT in Aggr() Function.

Regards

Muthu
Partner - Creator III
Partner - Creator III

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
MVP
MVP

Goto General tab->Default Search Mode ->Wildcard

Or, use like *NO* while searching.

Not applicable
Author

The Wildcard Search function worked perfectly! 🙂