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: 
SWeersing
Contributor
Contributor

Match error in expression

I am trying to find a match between two columns of data

Match(CompareA[Compare1 (Id, Item, Assignment date)])

Compare A is one column of date, and Compare1 is another column of data.

I receive an error, 

Error in expression;  ')' expected

What should the expression be?

 

Labels (1)
1 Reply
MartW
Partner - Specialist
Partner - Specialist

please take a look at the documentation about this function
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFun...

the match-statement contains 2 parameters:

1 the field you want to check and then the data you want to check against. The data you want to check against can be an expression or just a string value.

also note that in the link Qlik provide some examples for the statement.