7 Replies Latest reply: Jan 29, 2016 7:13 AM by Stefan Wühl RSS

    "Not Like" Equivalent or Workaround Within Set Analysis

      Hello Qlikviewers

       

      I have a report at the moment that I need to exclude values that have 'Serv', 'Service', 'Front' and 'Fronting' within the name from Set Analysis.

       

      At the moment the expression I'm using is very basic

       

      Sum(Value)

       

      So I'm just wondering if there is a SQL NOT LIKE equivalent within set analysis that I can use to remove values that have the above within the name?