topic Re: optimization in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/optimization/m-p/1372090#M6923 <HTML><HEAD></HEAD><BODY><P>I guess your second expression should be (a-b)/b</P><P></P><P>If a and b are complex expressions themselves, like aggregations,</P><P>the first expression (a/b)-1 only calculates two of these aggregations, while the second expression (a-b)/b calculates three (assuming no caching of b expression result involved, which is the case for Qlik AFAIK).</P></BODY></HTML> Wed, 26 Jul 2017 09:13:46 GMT swuehl 2017-07-26T09:13:46Z optimization https://community.qlik.com/t5/Connectivity-Data-Prep/optimization/m-p/1372089#M6922 <HTML><HEAD></HEAD><BODY><P>in Qlikview development practices showed (a/b)-1 has better performance than (a-1)/b. why for these two equations equal number of operations are perform but it says (a/b)-1 was better. suggest me what is the reason </P></BODY></HTML> Fri, 02 Apr 2021 08:02:57 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/optimization/m-p/1372089#M6922 manoj217 2021-04-02T08:02:57Z Re: optimization https://community.qlik.com/t5/Connectivity-Data-Prep/optimization/m-p/1372090#M6923 <HTML><HEAD></HEAD><BODY><P>I guess your second expression should be (a-b)/b</P><P></P><P>If a and b are complex expressions themselves, like aggregations,</P><P>the first expression (a/b)-1 only calculates two of these aggregations, while the second expression (a-b)/b calculates three (assuming no caching of b expression result involved, which is the case for Qlik AFAIK).</P></BODY></HTML> Wed, 26 Jul 2017 09:13:46 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/optimization/m-p/1372090#M6923 swuehl 2017-07-26T09:13:46Z