Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-01-09 03:32 AM

Performance issue

I wonder how you could optimize the following expression:

Sum(If(Aggr(NODISTINCT Max([Date of Est.]), ID,[Year Quarter of Est.]) = [Date of Est.], COST))

I have 18 million rows, created by using a interval function, but where I have several rows within the same period of time.

But for the moment I am experiencing very slow response by using the above expression.

Anyone faced the same problem?

405 Views
0 Likes
1 Reply
Not applicable
‎2013-01-09 07:30 AM
Author

I solved this by simply using FirstSortedValue.

sum(aggr(FirstSortedValue(COST,-Date ), ID,[Year Quarter of Est.] ))

283 Views
0 Likes