topic Effect of decomposition of expression formulae on performance in QlikView

Effect of decomposition of expression formulae on performance

wdonckers — Mon, 26 Jan 2026 18:19:17 GMT

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,

tresB — Fri, 05 Dec 2014 09:43:33 GMT

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

Anonymous — Fri, 05 Dec 2014 13:41:22 GMT

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

Never tested it though.

Serhan