flag script in qlikview

[qlikapple]

 can anyoneplease help

Please find the inline table and requirement

PRNO	PR_CATEGORY
1	rootcause.123
2	sweart
3	123.rootcause
4	qwerty
5	rootcause
I Need the field	flag field as if the PR_CATEGORY is having the value Rootcause then it show has to be Yes else NO,
if(match(PR_CATEGOR,'*Rootcause*','Yes','No') as PR_ROOTCAUSE_FLAG
But I am not getting it

[qlikapple]

Can any one please look into it

[BlondeThursday]

Is it because the term is "rootcause" in your data but you're looking for "Rootcause"?

Qlik is extremely case sensitive.

[jensmunnichs]

Try this:

if(Wildmatch(PR_CATEGOR,'*Rootcause*'),'Yes','No') as PR_ROOTCAUSE_FLAG