6 Replies Latest reply: Jul 7, 2017 8:13 PM by Marco Wedel RSS

    Exclude Search Box

    Brett Austin

      Hello Qlik Community,

       

      I am trying to create a Search Object that will 'Exclude' the value entered by the user. 

      1) I was able to 'Exclude' the data using the following in a 'Generic' search object

      =Not WildMatch(FieldName, 'SearchValue')

       

      But I am not wanting the  user community to enter this string each and every time they want to 'exclude' the values form their result set.

       

      Therefore I tried to...

      1) Create a variable

      2) Create a user Input Box

      3) Create a button to apply the Exclude script above to the search field.  

           3a) Set an Action (Set in Field)

            or

           3b) Macro

       

      Neither approach worked.  Any ideas?

       

      Thank you!