topic Re: Match() Function in QlikView

Match() Function

micheledenardi — Fri, 20 Apr 2018 12:16:36 GMT

Hi guys,

I'm usign Match() function into a complex script expression to create one new field.

I'm using the following code:

And the result is:

For the "h" record DOCTYPE=null() so I thought that match() function returns -1 because Null is different from ZRE and ZOFR... but is not....

How can write the script to have the same result ?

I would like to avoid using an approach with "or isnull(DOCTYPE)" like:

if(not match(DOCTYPE,'ZRE','ZOFR') or isnull(DOCTYPE),-1,0) as Result

Because, as i wrote, the expression is very complex and i would like to resolve this issue without using "OR" statement.

sunny_talwar — Fri, 20 Apr 2018 12:19:56 GMT

Had similar issues with match and null values

Not sure if this is any better, but look at result 2

Load

not match(DOCTYPE,'ZRE','ZOFR') as Result,

not (DOCTYPE Like 'ZRE' or DOCTYPE Like 'ZOFR') as Result2;

load * inline [

DOCTYPE,text

ZRE,a

ZOFR,b

YOFR,c

YOF,d

ZOE,e

ZOF,f

ZMTE,g

];

micheledenardi — Fri, 20 Apr 2018 12:30:35 GMT

Super Sunny !!!