topic Re: WHERE multiple values in script in QlikView

WHERE multiple values in script

stuwannop — Wed, 10 Jul 2013 10:44:31 GMT

Hi All

Assume this is very straightfoward but I can't find the answer.

When running my script with the WHERE clause I can only pull data that matches one criteria e.g.

WHERE Opportunity = 'Won'

How do I run the script on two criteria in the same field - normally I would go:

WHERE Opportunity = 'Won' AND Opportunity = 'Open'

This seems a bit cumbersome, especially if I have a list of values all relating to the same field. Is this the only way of doing it or is there something like WHERE EXISTS or something?

Thanks

Stu

Re: WHERE multiple values in script

nirav_bhimani — Wed, 10 Jul 2013 10:50:04 GMT

Hi,

You can used the following expression

WHERE wildmatch('Opportunity','Won','Open');

Regards,

Nirav Bhimani

Re: WHERE multiple values in script

swuehl — Wed, 10 Jul 2013 10:57:01 GMT

LOAD OpportunityMatchField FROM OpportunityMatchTable;

LOAD

....

FROM ....

WHERE EXISTS(OpportunityMatchField, Opportunity);

Re: WHERE multiple values in script

Sokkorn — Wed, 10 Jul 2013 10:59:29 GMT

Hi Stuart,

Match function will do this job.

Ex. Where Match(Opportunity,'Won','Open')

And if you want to use whildcard then use WildMatch() function

Ex. Where WildMatch(Opportunity,'*Won*','*Open*')

Regards,

Sokkorn

Re: WHERE multiple values in script

stuwannop — Wed, 10 Jul 2013 11:24:27 GMT

Thanks very much everyone that's really helpful.

Cheers.