Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
mwallman
Creator III
Creator III

Expression question

Hi I read in some QlikView documentation that:

date(max(ORDERDATE,'DD/MM/YYYY')) is 3 times faster than

max(date(ORDERDATE,’DD/MM/YYYY’) )

Can anyone please tell me why? This is better? There was no explanation when I read it at the time.

1 Reply
petter
Partner - Champion III
Partner - Champion III

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.

The second expression is an aggregation that needs to perform the function Date() on a field during aggregation. This slows it down - naturally.