Not equal to statement in Qlik Sense

[#1]

Hi,

I have created a single table after joining the few tables (called X) and now I want get rid of few rows that do not meet criteria (where Campaign is not blank).  I am doing a resident load and creating a table Y to get rid of records that have Campaigns field as blank. Syntax shown below.

Unfortunately it does not work and still brings back the records that have Campaign field as blank.  Can somebody guide me please as I am new to Qlik sense.

I have also unchecked the Show zero value box under Data handling while using bar charts and other UI elements but does not seem to help either. 

Thanks and Regards,

Monica

Y:

NoConcatenate

LOAD *

Resident X

where Campaign <> '';

Drop Table X;

[sunny_talwar]

How about this:

Y:

NoConcatenate

LOAD *

Resident X

Where Len(Trim(Campaign)) > 0;

Drop Table X;

[#3]

Awesome, you are a star Sunny .

Very helpful

[#4]

Y:

NoConcatenate

LOAD * Resident x Where Campaign <> '';

DROP Table x;

you can use too

where len(trim(Campaign))>0

or

where  nor isnull(Campaign)

[#5]

Thank you both of them work.