topic Master Items: Is the performance of a Calculated Dimension improved if it is stored as a Master Item and reused in multiple charts? in App Development https://community.qlik.com/t5/App-Development/Master-Items-Is-the-performance-of-a-Calculated-Dimension/m-p/123976#M8620 <HTML><HEAD></HEAD><BODY><P>Hi Qlik friends,</P><P></P><P>Is the performance of a Calculated Dimesion improved if it is used in multiple charts and stored as a Master Item?</P><P></P><P>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).</P><P></P><P>If you move it to Master Items Dimension and then use it as a Dimension in multiple charts, will the performance be better?</P></BODY></HTML> Mon, 09 Jul 2018 15:51:52 GMT jblomqvist 2018-07-09T15:51:52Z Master Items: Is the performance of a Calculated Dimension improved if it is stored as a Master Item and reused in multiple charts? https://community.qlik.com/t5/App-Development/Master-Items-Is-the-performance-of-a-Calculated-Dimension/m-p/123976#M8620 <HTML><HEAD></HEAD><BODY><P>Hi Qlik friends,</P><P></P><P>Is the performance of a Calculated Dimesion improved if it is used in multiple charts and stored as a Master Item?</P><P></P><P>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).</P><P></P><P>If you move it to Master Items Dimension and then use it as a Dimension in multiple charts, will the performance be better?</P></BODY></HTML> Mon, 09 Jul 2018 15:51:52 GMT https://community.qlik.com/t5/App-Development/Master-Items-Is-the-performance-of-a-Calculated-Dimension/m-p/123976#M8620 jblomqvist 2018-07-09T15:51:52Z Re: Master Items: Is the performance of a Calculated Dimesion improved if it is used in multiple charts and stored as a Master Item? https://community.qlik.com/t5/App-Development/Master-Items-Is-the-performance-of-a-Calculated-Dimension/m-p/123977#M8621 <HTML><HEAD></HEAD><BODY><P>Technically no Qlik experts concluded that there will be an improvement to performance.</P><P></P><P>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</P><P></P><P><A href="http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/" title="http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/">http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/</A></P></BODY></HTML> Mon, 09 Jul 2018 15:55:51 GMT https://community.qlik.com/t5/App-Development/Master-Items-Is-the-performance-of-a-Calculated-Dimension/m-p/123977#M8621 satishkurra 2018-07-09T15:55:51Z Re: Master Items: Is the performance of a Calculated Dimension improved if it is stored as a Master Item and reused in multiple charts? https://community.qlik.com/t5/App-Development/Master-Items-Is-the-performance-of-a-Calculated-Dimension/m-p/123978#M8622 <HTML><HEAD></HEAD><BODY><P>For performance reasons, it is recommended to perform all calculations in the data load editor. When dimensions are calculated in the chart, <SPAN class="CommonComponentsQlik Sense">Qlik Sense</SPAN> 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.</P><P></P><P>Check this:</P><P><A href="https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Dimensions/calculated-dimensions.htm" title="https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Dimensions/calculated-dimensions.htm">https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Dimensions/calculated-dimensions.htm</A></P></BODY></HTML> Mon, 09 Jul 2018 16:16:30 GMT https://community.qlik.com/t5/App-Development/Master-Items-Is-the-performance-of-a-Calculated-Dimension/m-p/123978#M8622 BalaBhaskar_Qlik 2018-07-09T16:16:30Z Re: Master Items: Is the performance of a Calculated Dimension improved if it is stored as a Master Item and reused in multiple charts? https://community.qlik.com/t5/App-Development/Master-Items-Is-the-performance-of-a-Calculated-Dimension/m-p/123979#M8623 <HTML><HEAD></HEAD><BODY><P>Check this link too:</P><P><A href="https://community.qlik.com/qlik-blogpost/3214">Logical Inference and Aggregations</A></P></BODY></HTML> Mon, 09 Jul 2018 16:18:04 GMT https://community.qlik.com/t5/App-Development/Master-Items-Is-the-performance-of-a-Calculated-Dimension/m-p/123979#M8623 BalaBhaskar_Qlik 2018-07-09T16:18:04Z