Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

WHERE Wildmatch()>0

Please can someone validate that

WHERE Wildmatch(field, condition)

is effectively

WHERE Wildmatch(field, condition) >0

To be safe, I always explicitly test for >0, but by I accidently discover that omitting yield the same result.

Tags (2)
1 Solution

Accepted Solutions
crusader_
Valued Contributor

Re: WHERE Wildmatch()>0

Hi,

Both are acceptable.

WildMatch(Field, Condition1, Condition2, Condition3) return respectively 1,2,3 etc if condition is true.

In QV False=0, other - TRUE

Hope this helps.

Andrei

2 Replies
anbu1984
Honored Contributor III

Re: WHERE Wildmatch()>0

Yes both are same

If return value of Wildmatch is zero, which is equivalent to false

If return value of Wildmatch is greater than zero, which is equivalent to true

crusader_
Valued Contributor

Re: WHERE Wildmatch()>0

Hi,

Both are acceptable.

WildMatch(Field, Condition1, Condition2, Condition3) return respectively 1,2,3 etc if condition is true.

In QV False=0, other - TRUE

Hope this helps.

Andrei

Community Browser