Qlik Sense apply like operator

[Anonymous]

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?

Many thanks!!

[sunny_talwar]

May be like this

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

[Anonymous]

Thanks it works well!!

[Anonymous]

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