Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Davide_Azzolini
Partner - Contributor
Partner - Contributor

RangeSum(Above( performance issue, how can it be fixed?

Hi, 

I have a performance issue using RangeSum. 

Here the expression:

RangeSum(Above(
Sum({$<Year = {$(=If(GetSelectedCount(Year) = 0 AND GetSelectedCount(MonthYear)=0, max(Year), Concat(Year, ',')))}>} value_fact)
, 0, RowNo()))

 

When I change filters, charts and tables takes too long to load the filtered data.

I tried to put RangeSum into the script, but it isn't what i want, I need a runtime calculation of that column. 

 

The question is: 

Do I need to upgrade my server to make rangesum faster? 

 

Thanks to all, Davide.

Labels (2)
1 Solution

Accepted Solutions
2 Replies
sunny_talwar

Use The As Of Table instead

Davide_Azzolini
Partner - Contributor
Partner - Contributor
Author

Very useful, thanks!