Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist
Specialist

how to show condn with not equals to ?

Hey,

I have a field whose values should not be equal to abc, def, ghi.

I tried:

Field<>{'ábc', 'def', 'ghi'} ;

But it is giving error.

Is there any other way ?

thanks

7 Replies
Not applicable

Thy {<Field-={'ábc', 'def', 'ghi'}>}

nigel987
Creator II
Creator II

Hi Nikhil,

try the following:

Field={"<>Value"}

Example: count({$<ID={"<>0"}>} user)

this counts all users which ID is not zero.

I hope this helps.

sunny_talwar

May be this:

If(not Match(Field, 'abc', 'def', 'ghi'), DoSomething, DoSomethingElse)

sunny_talwar

Within Set analysis you might be able to do this:

{<Field -= {'abc', 'def', 'ghi'}>}

sasiparupudi1
Master III
Master III

if using in set analysis

{<Field-={'abc', 'def', 'ghi'}>}

if you want to use it in an if condition

if (Field<>'abc' and Field<>'def' and Field<>'ghi',dosomething, dosomethingelse)

HTH

Sasi

Not applicable

with set analysis you can try like this {}

sinduabi
Contributor
Contributor

IF(Not Match(Field,'Val1','Val2'),Field)