topic Re: Problem with not in in QlikView

Problem with not in

Wed, 06 Aug 2014 14:37:07 GMT

Hello everyone,

I have a trouble with the LOAD part in my script.

I want to do :

if (CODE<>('800','810','830,'410','420','900'), 'Not OK') as [Flow]

But it doesn't work.

Is someone have any solution ?

Thanks !

PrashantSangle — Wed, 06 Aug 2014 14:39:45 GMT

Hi,

Try With wildmatch()

if (not wildmatch(CODE,'800','810','830,'410','420','900'), 'Not OK') as [Flow]

Regards,

its_anandrjs — Wed, 06 Aug 2014 14:40:29 GMT

Try and write another way

if( NOT Match(CODE,'800','810','830,'410','420','900'), 'Not OK') as [Flow]

MK_QSL — Wed, 06 Aug 2014 14:41:08 GMT

IF(NOT MATCH(CODE,'800','810','830','410','420','900'), 'Not OK') as [Flow]

maxgro — Wed, 06 Aug 2014 14:41:29 GMT

=if ( not match(CODE,'800','810','830','410','420','900'), 'Not OK', 'OK') as Flow

Wed, 06 Aug 2014 14:43:05 GMT

It works !

Thank you everyone