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

aggregation-help

hiee guys,

what is aggregation funtion and where it is used...i am having confusion when to use sum or when to use aggregation..please explain with some 'exapmle'.....

4 Replies
Anonymous
Not applicable
Author

Hi,

Below attached and url link may help you to understand qlikview aggregation.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/11/when-should-the-aggr-function-not-be-u...

Not applicable
Author

Hi,

check out this doc

hic
Former Employee
Former Employee

The Aggr() is not an aggregation function. In principle, you should never use Aggr() - unless you have a good reason to, and can explain why. Most calculations can be made using standard aggregations: Sum(), Min(), Max(), Count() etc.

Read about Aggregations and Function Classes and things will become clearer.

HIC

its_anandrjs
Champion III
Champion III

Hi,

Read the below mention documents for the Aggregation related help

QlikView Technical Brief - AGGR.docx

Hope this helps