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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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'.....

Labels (1)
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