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

pick, match and fuzzy search?

hii,

Whats is the difference between Pick and Match

What is Fuzzy search

Thank u in advance

Hita

1 Reply
alexandros17
Partner - Champion III
Partner - Champion III

Pick returns the nth expression in the list

pick(n, expr1[ , expr2,...exprN])

Pick( 2, 'A','B' ) returns B

Match compares strings and return yhe position of the one found

match( str, expr1 [ , expr2,...exprN ] )

Match( myField, 'Jan','Feb','Mar')  return 2 id myField is Feb

From Help:

Fuzzy search is similar to standard search, with the exception that it compares and sorts all field values according to their degree of resemblance to the search string. Fuzzy search is especially useful in situations where misspelling is an issue. It can also help you find multiple values that are nearly identical to each other.