Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER 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
MVP
MVP

Goto General tab->Default Search Mode ->Wildcard

Or, use like *NO* while searching.

View solution in original post

5 Replies

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

Master III
Master III

Hi,

Try to add DISTINCT in Aggr() Function.

Regards

Partner
Partner

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

MVP
MVP

Goto General tab->Default Search Mode ->Wildcard

Or, use like *NO* while searching.

View solution in original post

Not applicable

The Wildcard Search function worked perfectly! 🙂