topic Re: AGGR using index fields - performance in QlikView

AGGR using index fields - performance

georgina_spary — Tue, 02 Jun 2015 11:47:45 GMT

In an expression using AGGR, is it more performant to use a join field

=Sum(AGGR(ONLY([MyCount]), %%QV_RegnID))

or a non join field

=Sum(AGGR(ONLY([MyCount]), REGNID))

I know it's a bad idea to use join fields for display/ reporting but surely it's good to aggregate by an index? or is that not how QV works?

Re: AGGR using index fields - performance

marcus_sommer — Tue, 02 Jun 2015 12:00:18 GMT

Often it worked to calculate measures over KEY's but they could be have unexpected results. Therefore if it's possible you should avoid it and from a performance point of view aggr-functions could take a lot of ressources especially if they grab the data from many tables. Further see here: When should the Aggr() function NOT be used?.

- Marcus