exclude one value from the field

[qlikapple]

Hi

I  need to exclude one value form the field which is coming dirctly from tha table. How to do

[Anil_Babu_Samineni]

May be this?

If(Not WildMatch(FieldName , 'FieldValue'), FieldName)

Or

Aggr(Only({1<FieldName -= {'FieldValue'}>}FieldName), FieldName) // try without 1 operator

[tresesco]

If you don't need that anywhere in the dashboard, you should exclude it while loading using WHERE clause like:

Load

          status,

           ....

From <> Where status<>'DELETED' ;

[qlikapple]

i need to do that in script itself

i need to exclude 'DELETED'

[Anil_Babu_Samineni]

You can use like  below

LOAD * Inline [

Field

CREATED

DELETED

UPDATED

] Where Not WildMatch(Field, 'DELETED');