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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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