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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: 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.