topic exclude data in QlikView

exclude data

Tue, 08 Dec 2009 18:57:32 GMT

My syntax does not work. I still get everything but I want to exclude everything with MutatieType_ID 173

WHERE

("MutatieType_ID" <> '173' or "MutatieType_ID" <> '152' or "MutatieType_ID" <> '204');

I have also tried:

WHERE

("MutatieType_ID" <> '173' and "MutatieType_ID" <> '152' and "MutatieType_ID" <> '204');

Both do not work.

Can anybody tell me whats wrong?

Tue, 08 Dec 2009 19:04:49 GMT

Hi Richard,

try it without apostrophe (MutatieType_ID <> 173).

Rainer

Tue, 08 Dec 2009 19:05:13 GMT

remove " (double-qoutes) around the MutatieType_ID fieldname

Tue, 08 Dec 2009 19:28:51 GMT

Thx, it works. Weird thing though, because first I have to load it WITH the apostrophe and in the where-statement it's without.