Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

contains field not working properly

Hi,

I am trying to apply contains value in my if statement.

if i use [FROM] = '*MANNING*' ==> not working

if i use [FROM] LIKE  '*MANNING*' ==> working (But, not sure whether it is filtered correct or not

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

HI @saivina2920 

Try with wildmatch like

Wildmatch(From, '*manning*')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
MayilVahanan

HI @saivina2920 

Try with wildmatch like

Wildmatch(From, '*manning*')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Vegar
MVP
MVP

Is it used in a LOAD statement or in a SQL SELECT statement?

If it is a SQL SELECT statement then you should use SQL syntax for that database type. LIKE could be a valid statement, but wildmatch() is not.

If it is within a LOAD statement then you cannot use LIKE, it is not a part of the Qlik syntax. You can use wildmatch() instead as @MayilVahanan suggested.

saivina2920
Creator
Creator
Author

Thanks...we are using LOAD statement..