Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there a similar function to SQL 'LIKE' in QlikView script?

I have a field that I need to interrogate.

If it contains a certain string then it needs to do a 'textbetween' function on 2 characters, if it contains a different string then it does a 'textbetween' on 2 other characters.

logically I want to say:
if field TEXTCOL LIKE '%changed the field% then do this

else if field TEXTCOL LIKE '%user-defined%' then do that.

...if that makes sense...

thank in advance,

Matt

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Matt,

try WILDMATCH

cheers

Ask me about Qlik Sense Expert Class!