Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

qiuminzhang
New Contributor

Qlik Sense apply like operator

Hi All,

I am very new in Qlik Sense

I have a film name column, I'm going to have a dimension which has film name with "Punk". I know that in sql a LIKE operator could specify the pattern, but where can I specify or apply like operation in Qlik Sense?

This is the screenshot of that I put the like operator, but it doesn't work. Can anybody tell where or how to apply LIKE operator?

qlik like operator.png

Many thanks!!

Tags (1)
3 Replies

Re: Qlik Sense apply like operator

May be like this

If(title like '*punk*', title)

qiuminzhang
New Contributor

Re: Qlik Sense apply like operator

Thanks it works well!!

Re: Qlik Sense apply like operator

You may need to use the Match()‌ or Wildmatch()‌ functions

Community Browser