Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

WHERE statement

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 !

1 Solution

Accepted Solutions
dvasseur
Contributor II

Re: WHERE statement

Hi!

Maybe this:

SQL SELECT *

FROM `004 le calendrier`

WHERE NOT ((NUM_MOIS=2) AND (NUM_JOUR=30));

4 Replies
dvasseur
Contributor II

Re: WHERE statement

Hi!

Maybe this:

SQL SELECT *

FROM `004 le calendrier`

WHERE NOT ((NUM_MOIS=2) AND (NUM_JOUR=30));

Not applicable

Re: WHERE statement

try this

table_calendrier:

load *

WHERE NUM_MOIS<>2 AND  NUM_JOUR<>30;

SQL SELECT *

FROM `004 le calendrier`;

Re: WHERE statement

Hi

Try like this

Load * WHERE NOT NUM_MOIS&'_'&NUM_JOUR = 2_30;

SQL SELECT *

FROM `004 le calendrier`;

Not applicable

Re: WHERE statement

Thanks everyone, I think I'm just an idiot for not thinking of that solution.

Community Browser