Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
gabriele_qlik
New Contributor II

THE FASTEST SOLUTION

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

 

1 Solution

Accepted Solutions
Partner
Partner

Re: THE FASTEST 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

 

 

3 Replies
Masi_Sahargahi
New Contributor III

Re: THE FASTEST SOLUTION

Hi,

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

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

Partner
Partner

Re: THE FASTEST 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
New Contributor II

Re: THE FASTEST SOLUTION

Thank you 🙂