topic exclude one value from the field in QlikView

exclude one value from the field

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

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

Anil_Babu_Samineni — Fri, 16 Jun 2017 09:06:51 GMT

May be this?

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

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

tresB — Fri, 16 Jun 2017 09:11:21 GMT

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 — Fri, 16 Jun 2017 09:12:18 GMT

i need to do that in script itself

i need to exclude 'DELETED'

Anil_Babu_Samineni — Fri, 16 Jun 2017 09:15:24 GMT

You can use like below

LOAD * Inline [

Field

CREATED

DELETED

UPDATED

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