Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-03-12 12:21 PM

Performance issue with aggrigation dimension


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

221 Views
0 Likes
1 Reply
Carlos_Reyes
Partner - Specialist
Partner - Specialist
‎2014-03-12 02:24 PM

Perhaps these ideas may help.

  1. Create a composed field that integrates C_DT and IDESC into a single field and use that in the Aggr.
  2. 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.
  3. Optimize your expression " $(vAmount) "as much as possible.
114 Views