Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
I solved this by simply using FirstSortedValue.
sum(aggr(FirstSortedValue(COST,-Date ), ID,[Year Quarter of Est.] ))