4 Replies Latest reply: Oct 15, 2013 6:05 AM by Antonin Ramet RSS

    WHERE statement

    Antonin Ramet

      Hi there, I've got a shameful problem with some SQL.

       

      In my script, I load my DB, but I've figured out that there was some records in February 30th, so I want to remove them from the base in qlikview without delete them in the real DB.

       

      So when I load the concerned table, I do :

       

      table_calendrier:

      SQL SELECT *

      FROM `004 le calendrier`

      WHERE ((NUM_MOIS<>2) AND (NUM_JOUR<>30));

       

      The thing is that the WHERE doesn't work, it deletes all the data in february, not the 30th. Am I simply wrong vith my statement or there is a problem with my syntax ?

       

      Thanks !