topic Re: SelectInField Trigger with Search String Include wildcards and spaces in QlikView

SelectInField Trigger with Search String Include wildcards and spaces

Tue, 13 Oct 2015 15:43:19 GMT

I am trying to search for " PUSH " and " PER " and I want to include the space at the front and back to make sure I only get the single word, but when I add the wildcard * to the mix so that I can search within a text string I can't get the filter to work. Can someone help with the correct syntax. I have tried the 3 following options which seem to be the most logical, but none work. I have also tried some variations with single quotes with no luck.

(* PER *|* PUSH *)

("* PER *"|"* PUSH *")

(*" PER "*|*" PUSH "*)

I am also applying the UPPER() function to the Field to ignore the case sensitivity, could that be what is causing the problem?

Thanks!

Re: SelectInField Trigger with Search String Include wildcards and spaces

sunny_talwar — Tue, 13 Oct 2015 15:47:39 GMT

The middle one seems to work for me:

("* PER *"|"* PUSH *")

Re: SelectInField Trigger with Search String Include wildcards and spaces

Wed, 14 Oct 2015 14:01:45 GMT

Thanks! Apparently it was the button action that wasn't triggering, I moved the action to a text box and it worked

Re: SelectInField Trigger with Search String Include wildcards and spaces

sunny_talwar — Wed, 14 Oct 2015 14:03:51 GMT

Awesome

I am glad you were finally able to figure it out.

Best,

Sunny