Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Exclude from List Box with 'NOT LIKE'

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!!


1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Exclude from List Box with 'NOT LIKE'

Hi,

Try this simple one

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


Regards,

Jagan.

View solution in original post

4 Replies
Highlighted

Re: Exclude from List Box with 'NOT LIKE'

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

Highlighted
salto
Valued Contributor II

Re: Exclude from List Box with 'NOT LIKE'

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.

Highlighted
Not applicable

Re: Exclude from List Box with 'NOT LIKE'

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!


Highlighted
MVP & Luminary
MVP & Luminary

Re: Exclude from List Box with 'NOT LIKE'

Hi,

Try this simple one

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


Regards,

Jagan.

View solution in original post