Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon everyone.
I have an application, in which when doing any filter, the server's processing peak rises considerably (thus leaving the application for everyone who is using it extremely slow).
It returns to its normal speed, only when the selection is fully loaded.
Check if it is a complex calculation which could potentially be moved out to the Load Script.
If so, try moving the calculation (ie: calculated column or filter pane calculated field ) to the load script to see if that helps.
Just a thought
Kind regards...
There are multiple reasons that impact the performance
1)Complex data models
2)Complex Expressions
3) Complex calculated dimensions
4)Not enough ram (https://community.qlik.com/t5/Scalability/Scalability-Results-Analyzer/m-p/1493648#M1497)
5) or a combination of multiple or all of above reasons