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

Announcements
Join us in Toronto Sept 9th 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.