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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Any command similar to 'LIKE' operator of Oracle

I want to search for a word in a string and if it contains, do something.

is there any equivalent operator in Qlikview similar to 'LIKE' operator of Oracle?

if($(Path) like 'TEST') then

store $(PATH)/test.qvd;

end

3 Replies
swuehl
MVP
MVP

There is a LIKE string operator in QlikView, please search the Help for string operators.

maxgro
MVP
MVP

if(match($(Path), 'TEST'), ..., ...)

from online help

match( str, expr1 [ , expr2,...exprN ] )

The match function performs a case sensitive comparison.

mixmatch( str, expr1 [ , expr2,...exprN ] )

The mixmatch function performs a case insensitive comparison.

wildmatch( str, expr1 [ , expr2,...exprN ] )

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.

Example:

wildmatch( M, 'ja*','fe?','mar')

returns 1 if M = January

returns 2 if M = fex

Not applicable
Author

Thank you. I just solved it using INDEX() function

IF index('$(Path)','TEST')  > 0 THEN

    STORE Cust INTO $(Path)Cust.qvd ;

END IF