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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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