In My previous question I was prompted with an expression that solves the question of interest. This expression works in Qlik Sense, but does not work correctly in QlikView. Can you please tell me why this is the case?
The expression is:
Count({< >+<status={'in work'},[closing date],[date of registration]={"<=$(=Max([closing date]))"},[reference number]-=p({<[closing date]={">=$(=Date(0))"}>})>} distinct [reference number])