Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jade
Contributor III
Contributor III

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