Master Items: Is the performance of a Calculated Dimension improved if it is stored as a Master Item and reused in multiple charts?

[jblomqvist]

Hi Qlik friends,

Is the performance of a Calculated Dimesion improved if it is used in multiple charts and stored as a Master Item?

Let's say it was a calculated dimension based on AGGR and IF statements and you are using this expression in multiple charts as individual expression in each (but still the same).

If you move it to Master Items Dimension and then use it as a Dimension in multiple charts, will the performance be better?

[satishkurra]

Technically no Qlik experts concluded that there will be an improvement to performance.

Please check this link for more explanation. This is for QV, however it applies to QlikSense as well. The reason is the back end engine is same for both QV and QS

http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/

[BalaBhaskar_Qlik]

For performance reasons, it is recommended to perform all calculations in the data load editor. When dimensions are calculated in the chart, Qlik Sense first calculates the dimension values, and then aggregates the measures for these calculated values, which affects the performance more than calculations in the load script.

Check this:

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Dimensions/calculated-dimensions.h...

[BalaBhaskar_Qlik]

Check this link too:

Logical Inference and Aggregations