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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Match Logic

Should this not work?

Thanks

if(Match(Opportunity.davey_HeaderCancelCode,'05','06','18','22','24','25','27') > 0,1,0) as HPermCancel,

10 Replies
tmumaw
Specialist II
Specialist II
Author

Found the problem.  CRM stored them without the leading 0 and SAP with the leading 0.  Resolved.