topic Re: Select in field with special characters in QlikView

Select in field with special characters

Mon, 27 Feb 2017 19:18:53 GMT

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.

Re: Select in field with special characters

Miguel_Angel_Baeyens — Mon, 27 Feb 2017 19:28:20 GMT

If the blank is a space (not a null) then use " " (space, without quotes) or

=" "

equal sign and quotes included.

If the value is a true null, you will not be able to select it.

Re: Select in field with special characters

vishsaggi — Mon, 27 Feb 2017 19:30:14 GMT

Try this?

= '(' & '(blank)' &')'

Re: Select in field with special characters

Mon, 27 Feb 2017 19:31:54 GMT

Hi Miguel,

It is actually not a space...it is written out as (blank). Other areas I have if(match(Field, '(blank)')=0, Field) but that formula would not work in the search string area.

Re: Select in field with special characters

Mon, 27 Feb 2017 19:33:22 GMT

Hi Vishwarath,

That didn't work

Re: Select in field with special characters

Miguel_Angel_Baeyens — Mon, 27 Feb 2017 19:35:50 GMT

Then try instead

=Chr(40) & 'blank' & Chr(41)

to scape the parentheses, which are valid syntax operators for search strings

Re: Select in field with special characters

vishsaggi — Mon, 27 Feb 2017 19:36:35 GMT

Can you share a sample to look into? Can you upload here using Use Advanced Editor ?

Re: Select in field with special characters

Mon, 27 Feb 2017 19:48:26 GMT

Hi Vishwarath,

Please see attached. This is a qlik doc that I just created to test with.

Re: Select in field with special characters

Mon, 27 Feb 2017 19:52:19 GMT

Tried that yesterday and it didn't work. I tried just now again, no workie

Re: Select in field with special characters

vishsaggi — Mon, 27 Feb 2017 20:18:10 GMT

Is this what you are going to get in your actual data as well? (blank) ?

May be try this?

LOAD IF(Left(A, 1) = Chr(40) OR RIGHT(A,1) = Chr(41), Mid(A,2,5), A) AS FieldA;

LOAD A

FROM yourdatasource;

Then use a button with Select in field name as FieldA

and search string as = '(' & 'blank' & ')'

Re: Select in field with special characters

sunny_talwar — Mon, 27 Feb 2017 20:27:26 GMT

Try this:

='?blank?'

Re: Select in field with special characters

sunny_talwar — Mon, 27 Feb 2017 20:28:06 GMT

Or ='*blank*'

Re: Select in field with special characters

Mon, 27 Feb 2017 20:33:02 GMT

Sunny,

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

Re: Select in field with special characters

sunny_talwar — Mon, 27 Feb 2017 20:34:19 GMT

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

Re: Select in field with special characters

sunny_talwar — Mon, 27 Feb 2017 20:35:30 GMT

Look here:

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

Re: Select in field with special characters

Mon, 27 Feb 2017 20:36:47 GMT

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