topic Re: WHERE statement in QlikView

WHERE statement

Tue, 15 Oct 2013 09:42:26 GMT

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 !

Re: WHERE statement

dvasseur — Tue, 15 Oct 2013 09:44:58 GMT

Hi!

Maybe this:

SQL SELECT *

FROM `004 le calendrier`

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

Re: WHERE statement

Tue, 15 Oct 2013 09:49:08 GMT

try this

table_calendrier:

load *

WHERE NUM_MOIS<>2 AND NUM_JOUR<>30;

SQL SELECT *

FROM `004 le calendrier`;

Re: WHERE statement

MayilVahanan — Tue, 15 Oct 2013 09:50:18 GMT

Try like this

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

SQL SELECT *

FROM `004 le calendrier`;

Re: WHERE statement

Tue, 15 Oct 2013 10:05:11 GMT

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