topic Displaying latest Process Date in QlikView https://community.qlik.com/t5/QlikView/Displaying-latest-Process-Date/m-p/146626#M25153 <HTML><HEAD></HEAD><BODY><P>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'.</P></BODY></HTML> Fri, 12 Jun 2009 01:58:41 GMT 2009-06-12T01:58:41Z Displaying latest Process Date https://community.qlik.com/t5/QlikView/Displaying-latest-Process-Date/m-p/146626#M25153 <HTML><HEAD></HEAD><BODY><P>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'.</P></BODY></HTML> Fri, 12 Jun 2009 01:58:41 GMT https://community.qlik.com/t5/QlikView/Displaying-latest-Process-Date/m-p/146626#M25153 2009-06-12T01:58:41Z Displaying latest Process Date https://community.qlik.com/t5/QlikView/Displaying-latest-Process-Date/m-p/146627#M25154 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using? "=Max(Process_Date_Field)" should probably do it.</P></BODY></HTML> Fri, 12 Jun 2009 02:02:01 GMT https://community.qlik.com/t5/QlikView/Displaying-latest-Process-Date/m-p/146627#M25154 2009-06-12T02:02:01Z Displaying latest Process Date https://community.qlik.com/t5/QlikView/Displaying-latest-Process-Date/m-p/146628#M25155 <HTML><HEAD></HEAD><BODY><P>That is what I am using, but am getting Error in Calculated Dimension</P></BODY></HTML> Fri, 12 Jun 2009 02:11:10 GMT https://community.qlik.com/t5/QlikView/Displaying-latest-Process-Date/m-p/146628#M25155 2009-06-12T02:11:10Z Displaying latest Process Date https://community.qlik.com/t5/QlikView/Displaying-latest-Process-Date/m-p/146629#M25156 <HTML><HEAD></HEAD><BODY><P>If you're using aggregation in calculated dimension (in this case max), make sure to use aggr():<BR /><STRONG>=aggr(Max(Process_Date_Field), Field)</STRONG><BR />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.</P></BODY></HTML> Fri, 12 Jun 2009 02:22:22 GMT https://community.qlik.com/t5/QlikView/Displaying-latest-Process-Date/m-p/146629#M25156 Anonymous 2009-06-12T02:22:22Z