Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Problem with excluding data in script

Hi

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!

2 Replies
Highlighted
Champion
Champion

Problem with excluding data in script

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

hope this helps

Highlighted
Partner
Partner

Problem with excluding data in script

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,