Hi all

[#1]

Can any one explain what is  wild card search?  what are the uses and how to use wild card?

[sujeetsingh]

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).

1. Data: 
2. LOAD * INLINE [ 
3. Name, Value 
4. Advanced, 100 
5. Ultimate, 900 
6. Normal, 50 
7. ] 
8. WHERE Name LIKE 'A*';  
9. // this is the same as 
10. // WHERE Left(Name, 1) = 'A'; 

Hope that helps.

Miguel

[ashfaq_haseeb]

Hi,

Check this

can any one explain mixmatch,wildmatch with example?

Re: wildcard search in associative search

Re: Wildcard search

Regards

ASHFAQ

[sujeetsingh]

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

[sujeetsingh]

Scripting Wildcard

[vardhancse]

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