topic Expression question in QlikView https://community.qlik.com/t5/QlikView/Expression-question/m-p/1055309#M353837 <HTML><HEAD></HEAD><BODY><P>Hi I read in some QlikView documentation that:</P><P></P><P>date(max(ORDERDATE,'DD/MM/YYYY')) is 3 times faster than</P><P>max(date(ORDERDATE,’DD/MM/YYYY’) )</P><P></P><P>Can anyone please tell me why? This is better? There was no explanation when I read it at the time.</P></BODY></HTML> Fri, 11 Mar 2016 13:31:25 GMT mwallman 2016-03-11T13:31:25Z Expression question https://community.qlik.com/t5/QlikView/Expression-question/m-p/1055309#M353837 <HTML><HEAD></HEAD><BODY><P>Hi I read in some QlikView documentation that:</P><P></P><P>date(max(ORDERDATE,'DD/MM/YYYY')) is 3 times faster than</P><P>max(date(ORDERDATE,’DD/MM/YYYY’) )</P><P></P><P>Can anyone please tell me why? This is better? There was no explanation when I read it at the time.</P></BODY></HTML> Fri, 11 Mar 2016 13:31:25 GMT https://community.qlik.com/t5/QlikView/Expression-question/m-p/1055309#M353837 mwallman 2016-03-11T13:31:25Z Re: Best practise: Which expression is better and why? https://community.qlik.com/t5/QlikView/Expression-question/m-p/1055310#M353838 <HTML><HEAD></HEAD><BODY><P>It is due to the fact that the aggregation is done directly on a field. And then the Date() function is performed once at the end of the aggregation.</P><P></P><P>The second expression is an aggregation that needs to perform the function Date() on a field during aggregation. This slows it down - naturally.</P></BODY></HTML> Fri, 11 Mar 2016 14:07:10 GMT https://community.qlik.com/t5/QlikView/Expression-question/m-p/1055310#M353838 petter 2016-03-11T14:07:10Z