topic Re: flag script in qlikview in QlikView

flag script in qlikview

qlikapple — Sat, 16 Nov 2024 02:39:28 GMT

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 — Fri, 23 Aug 2019 09:27:46 GMT

Can any one please look into it

BlondeThursday — Fri, 23 Aug 2019 09:35:03 GMT

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

Qlik is extremely case sensitive.

jensmunnichs — Fri, 23 Aug 2019 09:42:39 GMT

Try this:

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