topic Re: Expression in Search String via Action button in QlikView

Expression in Search String via Action button

Thu, 14 Mar 2013 14:32:03 GMT

I'm trying to perform the following search string expression to select dates greater than >= in a master Calendar

Plan to re-use it various forms once I get this working. Thanks

Want this to select >= dates. I can hard code it to work like this >=2/14/2012

>='=AddYears(AddMonths(Today(),-1),-1)'

='=AddYears(AddMonths(Today(),-1),-1)' will select all dates.

This works:

=AddYears(AddMonths(Today(),-1),-1)

Re: Expression in Search String via Action button

Thu, 14 Mar 2013 14:33:32 GMT

Hi,

Can you attach the sample application

Re: Expression in Search String via Action button

Thu, 14 Mar 2013 14:37:55 GMT

Sure, just attached to original post. Thanks

Re: Expression in Search String via Action button

Thu, 14 Mar 2013 14:54:23 GMT

Additionally I found these post helpful.

http://community.qlik.com/message/3358#3358

http://community.qlik.com/message/137680#137680

Re: Expression in Search String via Action button

Thu, 14 Mar 2013 17:16:14 GMT

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

='>='&'$(vLastYear)'

Re: Expression in Search String via Action button

Tue, 02 Apr 2013 09:22:00 GMT

Hi Brian,

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:

='LIKE'&'$(variable)'

but this won't work.

Any suggestion is welcome.

Greetings

Wiley_E_

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.

Re: Expression in Search String via Action button

Tue, 02 Apr 2013 13:44:18 GMT

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