Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

exclude one value from the field

Hi

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

4 Replies
Anil_Babu_Samineni

May be this?

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

Or

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tresesco
MVP
MVP

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
Creator
Creator
Author

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');

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful