topic Re: Help Re-write aggr expression - faster application in QlikView

Help Re-write aggr expression - faster application

Anonymous — Wed, 31 Jan 2018 13:50:17 GMT

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?

Re: Help Re-write aggr expression - faster application

sunny_talwar — Wed, 31 Jan 2018 14:06:29 GMT

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

Re: Help Re-write aggr expression - faster application

marcus_sommer — Wed, 31 Jan 2018 16:04:54 GMT

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