Solved: Displaying latest Process Date - Qlik Community

Report Inappropriate Content · ‎2009-06-11

I have a field named Daily Process Date. I am trying to display only the latest date in a straight table, but keep getting 'Error in Calculation'.

Anonymous · ‎2009-06-11

If you're using aggregation in calculated dimension (in this case max), make sure to use aggr():
=aggr(Max(Process_Date_Field), Field)
I can't tell without knowing more details what field you should use for aggregation. Think of what you would use if it was GROUP BY. It could be a list of fields as well.

View solution in original post

Report Inappropriate Content · ‎2009-06-11

What is the expression you are using? "=Max(Process_Date_Field)" should probably do it.

Report Inappropriate Content · ‎2009-06-11

That is what I am using, but am getting Error in Calculated Dimension

Anonymous · ‎2009-06-11

If you're using aggregation in calculated dimension (in this case max), make sure to use aggr():
=aggr(Max(Process_Date_Field), Field)
I can't tell without knowing more details what field you should use for aggregation. Think of what you would use if it was GROUP BY. It could be a list of fields as well.