topic Re: THE FASTEST SOLUTION in App Development

THE FASTEST SOLUTION

gabriele_qlik — Sat, 16 Nov 2024 05:47:47 GMT

Hi,

the following expressions give the same result:

- If(Condition, Sum({<Set Analysis>}Dimension_1), Sum({<Set Analysis>}Dimension_2))

- Sum({<Set Analysis>} If(Condition, Dimension_1,Dimension_2))

I want to say if there is a difference in terms of optimization? What is the fastest expression?

Thank You

Masi_Sahargahi — Mon, 20 May 2019 11:05:36 GMT

Hi,

what if you handle "if" statement in your set analysis part?

I think in this case you'll have the fastest way.

felcar2013 — Mon, 20 May 2019 11:17:08 GMT

check this link

"When is it best to use sum(if()) over Set Analysis in an expression?"

There is also a small Optimization manual.

for better performance use flags in the script and set analysis in the expressions

Best

Felipe

gabriele_qlik — Mon, 20 May 2019 13:42:48 GMT

Thank you 🙂