topic Hi all in QlikView

Hi all

Fri, 14 Nov 2014 08:54:21 GMT

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

Re: Hi all

sujeetsingh — Fri, 14 Nov 2014 08:55:21 GMT

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

Data:
LOAD * INLINE [
Name, Value
Advanced, 100
Ultimate, 900
Normal, 50
]
WHERE Name LIKE 'A*';
// this is the same as
// WHERE Left(Name, 1) = 'A';

Hope that helps.

Miguel

Re: Hi all

ashfaq_haseeb — Fri, 14 Nov 2014 08:58:02 GMT

Hi,

Check this

can any one explain mixmatch,wildmatch with example?

Re: wildcard search in associative search

Re: Wildcard search

Regards

ASHFAQ

Re: Hi all

sujeetsingh — Fri, 14 Nov 2014 08:58:13 GMT

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

Re: Hi all

sujeetsingh — Fri, 14 Nov 2014 08:58:29 GMT

Scripting Wildcard

Re: Hi all

vardhancse — Fri, 14 Nov 2014 09:00:12 GMT

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