Discussion Board for collaboration related to QlikView App Development.
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?
Try this simple one
=If(WildMatch([ID], '*INF*''), [ID])
View solution in original post
=if(wildmatch([ID], '*INF*'') > 0, [ID], '')
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.
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!