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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is different of Sum and Only function?

What is different of Sum and Only  in Aggregate function?

Can someone give me some example.

Thanks

1 Reply
adhudson
Creator II
Creator II

Hi,

     Both functions are quiet different.

     The 'Sum' function calculates the addition of more than one values given in the rows while the 'only' function returns only one value depending on your selection.

     And the number of values provided to the function also differs. The Only function accepts one value while the sum function accepts specified set of values to calculate the sum.

     In case, if you are providing only one value for both the functions as a parameter, obviously both the functions will give the same result. 

Regards

Andrew