Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

flag script in qlikview

 can anyoneplease help

Please find the inline table and requirement

 

PRNOPR_CATEGORY       
         
1rootcause.123       
2sweart       
3123.rootcause       
4qwerty       
5rootcause       
         
         
I Need the fieldflag 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        
         
Labels (1)
3 Replies
Highlighted
Creator
Creator

Re: flag script in qlikview

Can any one please look into it

Highlighted
Contributor III
Contributor III

Re: flag script in qlikview

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

Qlik is extremely case sensitive.

Highlighted
Creator III
Creator III

Re: flag script in qlikview

Try this:

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