topic Sum() behaviour in QlikView https://community.qlik.com/t5/QlikView/Sum-behaviour/m-p/1318617#M408943 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>does it make a difference perfomancewise?</P><P></P><PRE __default_attr="html" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14909589862725089 jive_text_macro" jivemacro_uid="_14909589862725089" modifiedtitle="true"> <P>sum(Value*ExchangeRate)</P> </PRE><P></P><PRE __default_attr="html" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14909590050176068 jive_text_macro" jivemacro_uid="_14909590050176068" modifiedtitle="true"> <P>sum(Value)*ExchangeRate</P> </PRE><P></P><P>You could assume that the second one is faster because its first sums all value and then multiplies it only <STRONG><EM>once</EM></STRONG> with the exchange rate.</P><P>But i dont know if thats the case in the QIX Engine.</P><P>Any thoughts are appreciated!</P><P></P><P>-Phil</P></BODY></HTML> Fri, 31 Mar 2017 11:19:25 GMT Anonymous 2017-03-31T11:19:25Z Sum() behaviour https://community.qlik.com/t5/QlikView/Sum-behaviour/m-p/1318617#M408943 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>does it make a difference perfomancewise?</P><P></P><PRE __default_attr="html" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14909589862725089 jive_text_macro" jivemacro_uid="_14909589862725089" modifiedtitle="true"> <P>sum(Value*ExchangeRate)</P> </PRE><P></P><PRE __default_attr="html" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14909590050176068 jive_text_macro" jivemacro_uid="_14909590050176068" modifiedtitle="true"> <P>sum(Value)*ExchangeRate</P> </PRE><P></P><P>You could assume that the second one is faster because its first sums all value and then multiplies it only <STRONG><EM>once</EM></STRONG> with the exchange rate.</P><P>But i dont know if thats the case in the QIX Engine.</P><P>Any thoughts are appreciated!</P><P></P><P>-Phil</P></BODY></HTML> Fri, 31 Mar 2017 11:19:25 GMT https://community.qlik.com/t5/QlikView/Sum-behaviour/m-p/1318617#M408943 Anonymous 2017-03-31T11:19:25Z Re: Sum() behaviour https://community.qlik.com/t5/QlikView/Sum-behaviour/m-p/1318618#M408944 <HTML><HEAD></HEAD><BODY><P>Not sure about the performance, but second one would only work if you have a single possible ExchangeRate for each of the combination of your dimension. If there are multiple Exchange Rates, it will become null</P></BODY></HTML> Fri, 31 Mar 2017 11:25:01 GMT https://community.qlik.com/t5/QlikView/Sum-behaviour/m-p/1318618#M408944 sunny_talwar 2017-03-31T11:25:01Z Re: Sum() behaviour https://community.qlik.com/t5/QlikView/Sum-behaviour/m-p/1318619#M408945 <HTML><HEAD></HEAD><BODY><P>Hello Sunny,</P><P></P><P>Im aware of that, thanks!</P></BODY></HTML> Fri, 31 Mar 2017 12:09:59 GMT https://community.qlik.com/t5/QlikView/Sum-behaviour/m-p/1318619#M408945 Anonymous 2017-03-31T12:09:59Z