Effect of decomposition of expression formulae on performance

[wdonckers]

Hi,

Supposing that Variable itself contains a rather complex expression.

Consider the following expression in a chart

$(Variable) - $(Variable)*Discount)

Would it be worthwile from a performance point of view to decompose this formula and rewrite it as follows:

$(Variable) * (1 - Discount)

I don't know if this would make a difference for the Qlik calculation engine.

regards,

W

[tresesco]

$(Variable) * (1 - Discount) - is the one I would go with. This one would be better(or, at least not worse).

[Anonymous]

I believe it makes a difference. The second formula should work better,assuming the outcomes of this blog post.

Never tested it though.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/14/the-qlikview-cache

BR

Serhan