topic Qlik SaaS - Search in the field without * in App Development

Qlik SaaS - Search in the field without *

profilejamesbond — Thu, 07 Aug 2025 09:08:17 GMT

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

Re: Qlik SaaS - Search in the field without *

marcus_sommer — Thu, 07 Aug 2025 15:03:00 GMT

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.

Re: Qlik SaaS - Search in the field without *

QFabian — Thu, 07 Aug 2025 16:47:37 GMT

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