THE FASTEST SOLUTION

[gabriele_qlik]

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]

Hi,

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

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

[felcar2013 · Accepted solution]

Hi

check this link

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

https://community.qlik.com/t5/QlikView-Creating-Analytics/When-is-it-best-to-use-sum-if-over-Set-Ana...

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]

Thank you 🙂