Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jade
Contributor II
Contributor II

If statement to match strings

Hi. Can someone help me how to solve this? 

if(WildMatch([Flag, Processing Method?] , 'Adobe & Manual','Manual','Adobe',)'Yes' ,'No')

My result is not correct for some. It is No though there's data from that 

Labels (3)
4 Replies
steeefan
Luminary
Luminary

Is you field name actually [Flag, Processing Method?]? What are the values in that field you are trying to match? It seems that you are not using any wildcards. Have you tried Match()?

anat
Master
Master

if(Match([Flag, Processing Method?] , 'Adobe & Manual','Manual','Adobe',)'Yes' ,'No')

Or else try with pick and match function

Cascader
Creator
Creator

if(WildMatch([Flag, Processing Method?], 'Adobe & Manual', 'Manual', 'Adobe') > 0, 'Yes', 'No')

Digvijay_Singh

Share some test data to identify the real issue in case its still not working from earlier responses