2 Replies Latest reply: Jan 13, 2016 3:51 PM by Vadim Muchnik RSS

    Syntax for condition "This field can not equal to or contain this value, regardless whether only one value is chosen or multiple"

    Vadim Muchnik

      Hello Qlik Community Comrades,

      I am new to QlikView and in advance thank you for your patience with my naiive questions!

       

      I am building a conditional expression for a list box object.  There are several conditions.  One of the conditions is tied to a field that can have multiple filters (user interacts with pick list through checkboxes).

       

      In plain English, the condition is "This field can not contain this value, regardless whether only one value is chosen or multiple."  I tried <>, NOT, Where, Exists, text strings variations and can not come up with the right syntax.  The only "mini success" I had was to use <>.  it works like a charm when only one value is selected but gets broken as soon as more values are chosen.

       

      Any recommendations will be much appreciated!  Thank you in advance!

      Vadim