Select in field with special characters

[#1]

Hi All,

I'm creating a new dashboard and I have a button that is supposed to select a few parameters for the users. One of the fields I'm trying to select has a value of (blank). When I select in field and put in a search string for just (blank) nothing gets selected. I've tried

="(blank)"  and a few others with no luck. Does anyone know how I can get that working.

[sunny_talwar · Accepted solution]

Try this:

='?blank?'

[sunny_talwar]

Or ='*blank*'

[#4]

Sunny,

That worked in production!!!!!! Question...what does the ? stand for??

[sunny_talwar]

'?' is a single character wildcard search and '*' is multiple character wildcard search

[sunny_talwar]

Look here:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Text_search_and_numeric_search.h...‌

[#7]

Nice!!! Thank you Sunny and everyone for helping with this!!!!