topic Problem with excluding data in script in QlikView

Problem with excluding data in script

Fri, 23 Mar 2012 09:52:16 GMT

I want to exclude all data that are connected to a testuser. SFTEST, on that I´m trying to exclude post that don´t have FROMDAT or TOMDAT. I don´t get it working...

From .... qvd

WHERE ((NOT ISNULL(FROMDAT) OR NOT ISNULL(TOMDAT) OR Substringcount(Upper(INSHAND),'SFTEST')=0));

Can I do this or do I have to solve it on some other way?

BTW, by Substringcount(Upper(INSHAND),'SFTEST')=0)) seems only to exclude the user SFTEST from Userlist(INSHAND) but not the connected data(?)

/thanks!

Problem with excluding data in script

SunilChauhan — Fri, 23 Mar 2012 09:55:06 GMT

WHERE ((NOT ISNULL(FROMDAT) and NOT ISNULL(TOMDAT) and Substringcount(Upper(INSHAND),'SFTEST')=0));

hope this helps

Problem with excluding data in script

vmrodrigues — Fri, 23 Mar 2012 10:02:52 GMT

Hi,

Why don't you try just to use the EXISTS function? Something like:

LOAD

....

FROM ...

WHERE NOT EXISTS(SFTEST_KEY,'TEST_KEY_TO_EXCLUDE');

Cheers,