Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help required in using LIKE Operator with WHERE condition!

Hi

How to use the LIKE Operator with Where condition while loading data from QVD. I tried something like below but it is not returning any rows. Please help me out!

Log:

LOAD
Path,
.
.
.
.
FROM

(qvd)
Where Path LIKE 'c:\apps\product%';


Thanks

Attitude

5 Replies
gussfish
Creator II
Creator II

Hi,

QlikView isn't SQL! The wildcards that QlikView's LIKE operator

supports are * (for any number of characters) and ? (for exactly single

character).

Angus.

Miguel_Angel_Baeyens

Hello,

You can use it with the asterisk

Table:

LOAD F1

FROM Table.qvd (qvd)

WHERE F1 LIKE 'AA*';

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

Hi All

I think the use of WILDMATCH will do the trick. I guess it is working! Yet to test it... 🙂

Log:
LOAD
Path,
.
.
.
.
FROM

(qvd)
Where WILDMATCH(Path,'*c:\apps\product*');


Thanks

Attitude

Miguel_Angel_Baeyens

Hi,

Yes, that will work. Anyway, WildMatch is used when you need to compare to multiple values (very similar to the IN clause in SQL). If you only need one value, LIKE will do.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

Thanks Miguel

Your trick has done the trick! If you have free time could you please suggest something for me in the below post.

http://community.qlik.com/message/125391#125391

Regards

Attitude

Message was edited by: At titude. Replaced the link which was wrong before