Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one explain what is wild card search? what are the uses and how to use wild card?
Hi,
Match() and MixMatch() and WildMatch() will do, specially this last one, they are a combination of IN and LIKE. But the LIKE operator exists and works in QlikView as well. This Data table will return only one row (Advanced, 100).
Hope that helps.
Miguel
where
wildmatch(Field1, '?????-????-*')
;
from online help
wildmatch( str, expr1 [ , expr2,...exprN ] )
The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( *and ?) in the comparison strings.
Example:
wildmatch( M, 'ja*','fe?','mar')
returns 1 if M = January
returns 2 if M = fex
wild card search is nothing but searching the related to our text:
*a*
so a related search will be done in the objects like list box