SQL LIKE FUNCTION IN QLIKVIEW?

[#1]

Hi,

Is there a sql like function in qlikview?

Thanks

Laura

[#2]

Hi.

Yes. You can find it in the referential manuel "Advanced Search"

[#3]

In your where clause use

     MixMatch(FieldName, 'String1', 'String2', 'String3')>0

Of course this only works on the Load statement and not the SQL Select

Sorry read the question wrong.  The above reply is for a SQL IN statement.  The post below is correct with WildMatch(FieldName, 'String1*')>0

[Miguel_Angel_Baeyens]

Hi Laura,

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

[#5]

Hi,

Please use "wildmatch" function which is equivalent for (LIKE, NOT LIKE, IN) in SQL. Moreover wildmatch will do and case insensitive comparison.

Ex:

LOAD

Col 1,

Col 2

Col 3

FROM

....

WHERE

Wildmatch(Col 1, *A*);

[Anonymous]

Hi,

And how can I do if I wish for a  NOT LIKE function at the LOAD script?

Thanks,

Le Scorda

[nicolett_yuri]

NOT LIKE

WILDMATCH( Field01, 'Value01', 'Value02')=0

that way you delete these values

[siz_mahleka]

I'm not 100% sure which version the LIKE function was introduced into QlikView but I'm using 11.2 and you can simply use LIKE as you would do in SQL except you use * as opposed to % for wild matches.

LOAD *

FROM [.\Expenses.QVD](QVD)

WHERE TeamMember LIKE '*mahleka*';

[#9]

II'm going to try not LIKE to see if it works.

[#10]

HI

MATCH(),

WILDMATCH()