Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Not equal to statement in Qlik Sense

How about this:

Y:

NoConcatenate

LOAD *

Resident X

Where Len(Trim(Campaign)) > 0;

Drop Table X;

Not applicable

Re: Not equal to statement in Qlik Sense

Awesome, you are a star Sunny .

Very helpful

Not applicable

Re: Not equal to statement in Qlik Sense

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

Re: Not equal to statement in Qlik Sense

Thank you both of them work. 

Community Browser