topic Re: Listbox expression and search functionality not working in QlikView

Listbox expression and search functionality not working

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

I have a listbox and use an expression to pull the data

aggr(only ({<Paneuropean={'Ford','Fiat','GEMB', 'Santander', 'Toyota'}>}Paneuropean),Paneuropean)

However, when I select the search button to look for these entries, they do not appear in the search field.

The rest of my app links to these but just the search field in the listbox doesn't.

Any ideas?

Re: Listbox expression and search functionality not working

swuehl — Mon, 30 Nov 2015 11:42:36 GMT

Can't reproduce this behaviour. With Seach button, you are referring to the search bar in the header of the list box?

Could you upload a small sample QVW that demonstrates your issue?

Re: Listbox expression and search functionality not working

bobbydave — Mon, 30 Nov 2015 11:43:58 GMT

Yes, I am referring to the search bar in the header.

I will try to create a dummy application.

Re: Listbox expression and search functionality not working

Anonymous — Mon, 30 Nov 2015 11:46:20 GMT

try this only:

only ({<Paneuropean={'Ford','Fiat','GEMB', 'Santander', 'Toyota'}>} Paneuropean)

Re: Listbox expression and search functionality not working

bobbydave — Mon, 30 Nov 2015 11:59:48 GMT

Find attached an example.

Paneuropean has a number of entries but in my listbox expression, I have limited to show only what I need.

Now if I select the Search functionality in the header of this listbox and try to do a search, it comes up empty.

Any ideas how to resolve this?

Re: Listbox expression and search functionality not working

bobbydave — Mon, 30 Nov 2015 12:00:30 GMT

This didn't work.

However, I have attached a dummy application if you need to look at what I am trying to accomplish.

Thanks

Re: Listbox expression and search functionality not working

himanshi — Mon, 30 Nov 2015 12:05:21 GMT

hii,

you can try this. In settings - document properties go to presentation tab and use wildcard search.

Regards,

Himanshi

Re: Listbox expression and search functionality not working

swuehl — Mon, 30 Nov 2015 12:08:57 GMT

Ok, the list box values will appear if you complete the search (exact match)

Santander

or if you use a wildcard search

San*

edit: if you change the default search mode in list box properties to 'Use wildcard search', then you just can start typing

Re: Listbox expression and search functionality not working

bobbydave — Mon, 30 Nov 2015 12:13:52 GMT

With any other search functionality, you can do a full search and don't to need to use wildcards.

Is there a way around this or because I am using an expression, I am limiting myself to typing in the full completed search?

Re: Listbox expression and search functionality not working

settu_periasamy — Mon, 30 Nov 2015 12:17:05 GMT

May be, You can change the 'Normal Search' to Wildcard Search..

Document Properties -> Presentation Tab -> Default Search Mode -> Use WildCard Search

Re: Listbox expression and search functionality not working

jonathandienst — Mon, 30 Nov 2015 12:21:02 GMT

Did you see swuehl's update?

edit: if you change the default search mode in list box properties to 'Use wildcard search', then you just can start typing