topic Re: contains field not working properly in QlikView

contains field not working properly

saivina2920 — Fri, 15 Nov 2024 23:16:56 GMT

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

Re: contains field not working properly

MayilVahanan — Thu, 21 Jan 2021 04:01:39 GMT

HI @saivina2920

Try with wildmatch like

Wildmatch(From, '*manning*')

Re: contains field not working properly

Vegar — Thu, 21 Jan 2021 04:22:26 GMT

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.

Re: contains field not working properly

saivina2920 — Thu, 21 Jan 2021 10:08:22 GMT

Thanks...we are using LOAD statement..