Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
crusader_
Partner - Specialist
Partner - Specialist

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

View solution in original post

2 Replies
anbu1984
Master III
Master III

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_
Partner - Specialist
Partner - Specialist

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