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: 
Zaidan_as
Creator
Creator

Error Using Match Function When Load Data

Hello Experts,
So as i mention in the subject, I want to load data from load editor and I want filter the data using Where and Match Function.
So the error and my code is like this 

Zaidan_as_0-1647393860668.png

as you can see, the error stated that the first parameter of Match Function is wrong. But as I know when I read this article https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona... the first parameter is the column name. So how can I fixed this ? 

Labels (4)
1 Solution

Accepted Solutions
Zaidan_as
Creator
Creator
Author

I already found the solutions, just change the [field] to "field" in the first parameter. 
So this is the script 
Where MATCH("Agent Group Name",'SBM Apps team','SCC Apps Team','SPL Apps Team','SSIP Apps Team') > 0;

View solution in original post

1 Reply
Zaidan_as
Creator
Creator
Author

I already found the solutions, just change the [field] to "field" in the first parameter. 
So this is the script 
Where MATCH("Agent Group Name",'SBM Apps team','SCC Apps Team','SPL Apps Team','SSIP Apps Team') > 0;