Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Select field values with blank spaces in listbox

Hi all,

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

ListboxSelection.png

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Select field values with blank spaces in listbox

Hi,

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

Capture.PNG

View solution in original post

4 Replies
Highlighted
Not applicable

Re: Select field values with blank spaces in listbox

Hello,

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

it should work

2014-03-21_111845.png

Highlighted

Re: Select field values with blank spaces in listbox

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

Highlighted
Not applicable

Re: Select field values with blank spaces in listbox

Hi,

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

Capture.PNG

View solution in original post

Highlighted

Re: Select field values with blank spaces in listbox

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

Untitled.png