Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Not equal to statement in Qlik Sense

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;

4 Replies
sunny_talwar

How about this:

Y:

NoConcatenate

LOAD *

Resident X

Where Len(Trim(Campaign)) > 0;

Drop Table X;

Not applicable
Author

Awesome, you are a star Sunny .

Very helpful

Not applicable
Author

Y:

NoConcatenate

LOAD * Resident x Where Campaign <> '';

DROP Table x;

you can use too

where len(trim(Campaign))>0

or

where  nor isnull(Campaign)

Not applicable
Author

Thank you both of them work.