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.

[Miguel_Angel_Baeyens]

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.

[vishsaggi]

Try this?

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

[#4]

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.

[#5]

Hi Vishwarath,

That didn't work

[Miguel_Angel_Baeyens]

Then try instead

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

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

[vishsaggi]

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

[#8]

Hi Vishwarath,

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

[#9]

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

[vishsaggi]

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' & ')'