Qlik SaaS - Search in the field without *

[profilejamesbond]

Hi,
I have Dimension where I have number like 123_471235 like this.

Now, I would like to search text like 471235 instead of *471235*.

Other example: Abc_343_xz - I would like to search such as 343 instead of *343*

Is it possible to provide that functionality or to do it ?

Thanks

[marcus_sommer]

In QlikView were options (globally as well as per list-box) how a search should be performed - with or without wildcards as default one. Maybe in Sense are similar options also available.

Another approach might be to adjust the field with something like:

dual(Field, keepchar(Field, '0123456789')) as Field

whereby it could have risks in overlapping numerical values by removing delimiters and other string-parts.

[QFabian · Accepted solution]

Hi @profilejamesbond , you can check if works for you switching options in search mode inside field properties from a filter pane :

in normal mode :

and in wildcard mode, it automatically adds the asteriks when you click on the search button, so you just can search your text