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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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