Which type of calculations should be performed in the Qlik script when possible?

Performing calculations within the Qlik script is often the preferred approach because it optimizes the data model and reporting performance. When calculations are conducted during the data load, it allows the end-user experience to be more efficient, as the application retrieves pre-aggregated or pre-calculated data rather than recalculating values on-the-fly during data visualization instances.

This method also helps in minimizing the load on the application at the time of user interactions, as re-processing data in visualizations can slow down responsiveness, especially with large datasets. Moreover, when calculations are pre-defined in the script, this promotes data consistency, ensuring that everyone using the application references the same calculated values, thereby reducing confusion or discrepancies that can arise from ad hoc calculations in visualizations.

While other methods such as in-app visualizations, data model adjustments, or calculations during data export can be useful in certain scenarios, they do not offer the same level of performance optimization or data management advantages as executing calculations within the script.