Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
bharani8
Creator III
Creator III

Adding cumulative field - Degrading dashboard performance

Hi Experts - Any idea what is the work around for this? While adding the cumulative calculation field in an straight table, my dashboard performance is degrading (takes 5 to 10 Mins to refresh). Plz Help.. Let me know if any other info is required?

Thanks!

Bharani

11 Replies
qliksus
Specialist II
Specialist II

How many dimensions you have in the table? . Also just for testing can you reduce the data to around 5L and use the same expression and check the result it could be either because of RAM or a poor data model

marcus_sommer

I assume that you want to calculate it on many rows within the straight-table and this will take some time because each single row will need a separate calculation on the virtual table within the background: Logical Inference and Aggregations.

Personally I don't remember any special performance-issues with this kind of object and calculation but I remember other discussions about poor performance on it. One way to improve the performance could be to limit your table-rows by removing/replacing some very granular dimensions and/or conditions within the object/dimensions to display max. n number of rows.

A more general approach would be to look if there are possible optimizations within the datamodel - snowflake models or link-table approaches will have a lower gui-performance than a star-scheme or a big flat-table.

- Marcus