topic Exclude from List Box with 'NOT LIKE' in QlikView

Exclude from List Box with 'NOT LIKE'

Tue, 28 Oct 2014 07:41:02 GMT

Hi everyone,

I'm trying to filter the values in a list box based on where the value is NOT LIKE 'INF'

The query works when I say =if([ID] like '*INF*', [ID])

But it won't allow =if([ID] not like '*INF*', [ID])

Can someone please help with the correct syntax?

Thanks!!

alexandros17 — Tue, 28 Oct 2014 07:46:37 GMT

=if(wildmatch([ID], '*INF*'') > 0, [ID], '')

salto — Tue, 28 Oct 2014 07:49:39 GMT

Hello,

maybe changing the "then" and "else" order, like this:

=if([ID] like '*INF*', [Else value], [ID])

Or maybe this:

=if not ([ID] like '*INF*', [ID])

Hope this helps.

Tue, 28 Oct 2014 07:52:35 GMT

Awesome thanks so much!! I changed it to

= if(wildmatch([HFL FSAM ID], '*INF*') <> 1,[HFL FSAM ID])

to exclude the blanks as well and it works perfectly!!

Thanks again for the super quick response!

jagan — Tue, 28 Oct 2014 08:10:12 GMT

Hi,

Try this simple one

=If(WildMatch([ID], '*INF*''), [ID])

Regards,

Jagan.