Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ?
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;
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;