Performance issue with aggrigation dimension

Wed, 12 Mar 2014 16:21:43 GMT

Thanks to all for your sharing your suggestion

In my application there are calculated dimension as below

= If(aggr(Rank(sum($(vAmount))),C_DT , IDESC)<=10,'Top 10',
If(aggr(Rank(sum($(vAmount))),C_DT,IDESC)<=25, 'Top 25',
If(aggr(Rank(sum($(vAmount))),C_DT,IDESC)<=50, 'Top 50','Rest'
)))

Which took tremendous time, I can't incorporate in script as this is dynamic.

Any solution to avoid performance ?

Thanking you in advance

Re: Performance issue with aggrigation dimension

Carlos_Reyes — Wed, 12 Mar 2014 18:24:43 GMT

Perhaps these ideas may help.

Create a composed field that integrates C_DT and IDESC into a single field and use that in the Aggr.
Load the New Composed field into the Fact table. I've seen that when you use Aggr QV improves performance when the Aggr fields are in the same table as the field that's been calculated.
Optimize your expression " $(vAmount) "as much as possible.

topic Performance issue with aggrigation dimension in QlikView

Performance issue with aggrigation dimension

Re: Performance issue with aggrigation dimension