Error in set modifier ad hoc element list: "," or ")" missing

[test14]

What is wrong with that formula?

=Count(DISTINCT {<Customer_ID={=Max(OrderDate)-Max(OrderDate,2)>600000}>}Customer_ID)

it tells me that there is an "," or ")" missing, but I don't get it.

[GaryGiles]

You need to enclose the criteria in double quotes ", like this:

=Count(DISTINCT {<Customer_ID={"=Max(OrderDate)-Max(OrderDate,2)>600000"}>}Customer_ID)

[test14]

Thanks for your fast reply.

Unfortunately that returns another error (Error in expression)
without further information on the error.

[GaryGiles · Accepted solution]

I doubled checked the syntax of the expression I posted and it should be fine.  The only way I recieved a message of error in expression with no further information is if the field name was incorrect.  Is Customer_ID the correct field name?  Remember, Qlik is case sensitive, so Customer_Id is different than Customer_ID.

[test14]

You are absolutely correct, that was the mistake.
Thanks again for your help 🙂