Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
marius_larsen
Contributor II

Help Re-write aggr expression - faster application

Hi,

Need help re-write this to an easier expression;

((sum(aggr(

sum(kWh) * sum(aggr(sum(Price), DateJoin,Pricearea,CustomerKey)) , DateJoin, Year,Month, Pricearea,portifolio,CustomerKey))    ) / sum(kWh))*100

as it is now, it slows down my application too mutch. Any suggestion to solve this?

2 Replies
Highlighted

Re: Help Re-write aggr expression - faster application

Would you be able to share a sample to test out few possibilities?

Highlighted
MVP & Luminary
MVP & Luminary

Re: Help Re-write aggr expression - faster application

It's not surprising that a nested aggr-function is slow. Are you sure that you really need it?

Beside this quite often determined the datamodel how performant gui-calculations could be. Therefore a different data-structure could be quite useful - fo example to put kWh and Price within one table and avoiding the aggr-stuff. Further if your datamodel is build with link-tables I suggest to rethink the entire datamodel.

- Marcus