Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
vivekocbc
Contributor II
Contributor II

Fractile and Aggr function performance improvement

Hi All,

I have an application which has data of 13GB in which we are showing various statistics like mean, SD the issue is due to such large volume it is taking too long so, as a part of performance enhancement program we would like figure out if there is a way to make it faster.

As per my understanding AGGR function makes performance of dashboard slow so, would like to understand if we can make this below expression faster.

Fractile(Aggr( if(sum(DAILY_DEBIT_AMT)=0,Null(),sum(DAILY_DEBIT_AMT)/sum(DAILY_CREDIT_AMT)) ,AggDimMonthly),0.99)

To explain above expression, we are showing various fractile like 99%, 95%, 90%, 84%, 75%, 50% as separate bars like below chart.

Daily Fractile Image.png

Can you suggest a way to improvise above expression to make it faster and we cannot compute it script level because we want values to be computed dynamically based on filters.

 

Labels (1)
0 Replies