Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

Performance issue - Aggr function

Hi All,

I developed new app ,most of the KPIs in this app calculate with Aggr function and it worked fine (with ~1M records)

When I try to load more data (26 M records) the app drastically slows down and it's bring data only if we filtering the data.

 

Example for KPI calc:

Avg(if($(V_Date_LastMonth)=1 ,Aggr(
count(distinct if($(V_Date_LastMonth)=1 and Upper(Trim(ACTION))='OPENED',ID))
/
count(distinct if($(V_Date_LastMonth)=1 and Upper(Trim(ACTION))='DELIVERED',ID)),ISSUE))).

 

Could you please advise?

Thanks,

 

 

 

1 Solution

Accepted Solutions
Or
Master III
Master III

Try replacing your if() statements with set analysis. This typically has a major impact on performance.

View solution in original post

2 Replies
Or
Master III
Master III

Try replacing your if() statements with set analysis. This typically has a major impact on performance.

RutiTaumanRubin
Creator
Creator
Author

Thanks!

 

I change the calculation to set analysis  and add the following instead of Dim name: $(=GetObjectField(0,'CH24') and it's improve the performance