topic Re: SQL LIKE FUNCTION IN QLIKVIEW? in QlikView

SQL LIKE FUNCTION IN QLIKVIEW?

Fri, 13 Jan 2012 14:50:05 GMT

Hi,

Is there a sql like function in qlikview?

Thanks

Laura

Re: SQL LIKE FUNCTION IN QLIKVIEW?

Fri, 13 Jan 2012 15:17:17 GMT

Hi.

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

Re: SQL LIKE FUNCTION IN QLIKVIEW?

Fri, 13 Jan 2012 15:38:14 GMT

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

Re: SQL LIKE FUNCTION IN QLIKVIEW?

Miguel_Angel_Baeyens — Fri, 13 Jan 2012 16:04:28 GMT

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

Re: SQL LIKE FUNCTION IN QLIKVIEW?

Sun, 15 Jan 2012 06:46:17 GMT

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*);

SQL LIKE FUNCTION IN QLIKVIEW?

Anonymous — Thu, 26 Apr 2012 18:31:20 GMT

Hi,

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

Thanks,

Le Scorda

SQL LIKE FUNCTION IN QLIKVIEW?

nicolett_yuri — Thu, 26 Apr 2012 20:55:47 GMT

NOT LIKE

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

that way you delete these values

Re: SQL LIKE FUNCTION IN QLIKVIEW?

siz_mahleka — Sun, 20 Apr 2014 23:17:30 GMT

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*';

Re: SQL LIKE FUNCTION IN QLIKVIEW?

Tue, 23 Sep 2014 04:43:20 GMT

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

Re: SQL LIKE FUNCTION IN QLIKVIEW?

Tue, 23 Sep 2014 04:47:25 GMT

MATCH(),

WILDMATCH()

Re: SQL LIKE FUNCTION IN QLIKVIEW?

aveeeeeee7en — Tue, 23 Sep 2014 04:47:45 GMT

There are no. of Alternatives:

1) Wildmatch() function

2) Mixmatch() function

3) Use Button: Create Button> Actions > Select in Field >

Name: Field Name

Search String: *Search String*

Regards

Av7eN