Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (1)
2 Replies

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

May be look

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

Or

Not Like

Not applicable

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

Settu,

Many thanks!!!  It worked like a charm

I appreciate your support!

Vadim

Community Browser