topic Match in QlikView

Match

Wed, 16 Jul 2014 09:23:38 GMT

Hi,

How can I interptrete below from Qlikview to SQL

MATCH([Order No], '1','2','7','15','16','21') = 0

jonathandienst — Wed, 16 Jul 2014 09:30:07 GMT

Match NOT IN ('1','2','7','15','16','21')

Wed, 16 Jul 2014 09:31:18 GMT

I would like to write this on SQL, thanks Jonathan

its_anandrjs — Wed, 16 Jul 2014 09:31:27 GMT

Use Like function for this.

its_anandrjs — Wed, 16 Jul 2014 09:36:01 GMT

Try like

SELECT *

FROM Source

WHERE [Order No] NOT Like '1' OR '2' OR '7' OR '15' OR '16' OR '21' ;

its_anandrjs — Wed, 16 Jul 2014 09:40:13 GMT

Another way try

SELECT *

FROM Source

WHERE [Order No] NOT IN ( '1' ,'2', '7', '15' ,'16', '21');

ashfaq_haseeb — Wed, 16 Jul 2014 09:43:46 GMT

Try below

SELECT *

FROM Source

WHERE [Order No] NOT in(1,2,7,15,16,21);

Regards

ASHFAQ

its_anandrjs — Wed, 16 Jul 2014 09:47:31 GMT

One of the another way is

SELECT *

FROM Source

WHERE [Order No] NOT Like IN ( '1' OR '2' OR '7' OR '15' OR '16' OR '21' );

SELECT *

FROM Source

WHERE [Order No] NOT Like IN ( 1 OR 2 OR 7 OR 15 OR 16 OR 21 );

SELECT *

FROM Source

WHERE [Order No] NOT Like IN ( 1 , 2 , 7 , 15 , 16 , 21 );