Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to list box properties and in general-Search-Default Search Mode select "use wildcard search"
View solution in original post
Place the value between double quotes : "073 001 78 24"
it should work
use PurgeChar(phone, ' ') as expression instead of field phone and use search with special char
To make it work like that, try with the Wildcard search mode