Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
georgina_spary
Contributor II
Contributor II

AGGR using index fields - performance

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?

1 Solution

Accepted Solutions
marcus_sommer

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

View solution in original post

1 Reply
marcus_sommer

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