topic Re: Select field values with blank spaces in listbox in QlikView

Select field values with blank spaces in listbox

Fri, 21 Mar 2014 10:14:17 GMT

Hi all,

I've a listbox containing phone numbers (text format with blanks to separate the nuber blocks) like shown below:

Unfortunately when searching for a special phone number like '073 001 78 24' all phone numbers containing any of these number blocks are selected. Is there any setting allowing this?

Thanks,

Thomas

Re: Select field values with blank spaces in listbox

Fri, 21 Mar 2014 10:22:03 GMT

Hello,

Place the value between double quotes : "073 001 78 24"

it should work

Re: Select field values with blank spaces in listbox

alexandros17 — Fri, 21 Mar 2014 10:22:58 GMT

use PurgeChar(phone, ' ') as expression instead of field phone and use search with special char

Re: Select field values with blank spaces in listbox

Fri, 21 Mar 2014 10:35:09 GMT

Hi,

Go to list box properties and in general-Search-Default Search Mode select "use wildcard search"

Re: Select field values with blank spaces in listbox

CELAMBARASAN — Fri, 21 Mar 2014 10:37:05 GMT

To make it work like that, try with the Wildcard search mode