Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sazabi
Creator
Creator

How does the Qlik Engine handle having all the fields in a single sum()?

Hey Qlikers,

In terms of performance, does having all the fields in a single sum() work any faster than having it broken out into multiple sum()?

For example:

I have sum({<someSetAnalysis>}field1 + field2)

VERSUS

sum({<someSetAnalysis>}field1) + sum({<someSetAnalysis>}field2)

 

These should equate to the same value, but I am wondering if the Engine handles this any differently between the two? Any performance gains in keeping things together versus splitting them out? 

 

(I know the values will be different if I do any multiplication or division in the consolidated form, so I am speaking strictly to addition and subtraction )

 

Thanks!

 

S

0 Replies