4 Replies Latest reply: Jul 13, 2016 10:53 AM by Monica Chhabra RSS

    Not equal to statement in Qlik Sense

    Monica Chhabra

      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;