The key is wrapping it in single quotes and concating the expression parts using ‘ & ’
I tested it in a text box to make sure it was rendering it as a regular string vs. the expression. QVW attached as well
Master-Calendar-Toggle.qvw 215.5 K
I've got a similar problem, but simply cannot get it to work. Maybe you've got an idea:
Like you I need a search string button. But I'd like to enter the search value in an Input Box (much like any ordinary web search :-) ).
I already tried several sytnax (varying quotation marks,etc...) of the following manner in a 'selection in field'-button:
but this won't work.
Any suggestion is welcome.
P.S: I know, that I could simply use the search function in a multibox-field. However, later on, I need to look for the desired expression in several fields at once. Therefore the multibox is no option.
This post is the most similar to your request. http://community.qlik.com/message/137680#137680
They dont use LIKE, but use Sum with Set analysis in one example. using wildcard asterisks AB*
Where mine was evaulating dates so I used >= operators to limit range but syntax applies.
aslo may want to use wildmatch for string searches shown in post above
if(WildMatch(customer_type,'*AD*'),'Yes','No')as AD worked..
Hope this helps