Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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