Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

2 Replies
settu_periasamy
Master III
Master III

May be look

Not WildMatch(YourField,'*Value1*','Value2*')     

Or

Not Like

Not applicable
Author

Settu,

Many thanks!!!  It worked like a charm

I appreciate your support!

Vadim