topic Re: Aggr Function ? in QlikView

Aggr Function ?

Fri, 31 Oct 2014 18:19:01 GMT

HI All,

How to use Aggr function, Can you post some Examples with Some Examples...

Thanks,

Heather

Re: Aggr Function ?

its_anandrjs — Fri, 31 Oct 2014 18:24:19 GMT

Hi,

You can read this document for the AGGR this are good documents.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/16/use-the-aggregation-functions

http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/09/aggregation-scope

And follow this documents also

QlikView Technical Brief - AGGR.docx

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr

Regards

Anand

Re: Aggr Function ?

Gysbert_Wassenaar — Fri, 31 Oct 2014 18:25:23 GMT

See this blog post: AGGR... and this document: QlikView Technical Brief - AGGR.docx

Re: Aggr Function ?

maxgro — Fri, 31 Oct 2014 18:26:39 GMT

QlikView Technical Brief - AGGR

Aggr Statement White Paper

Re: Aggr Function ?

Anonymous — Fri, 31 Oct 2014 18:27:07 GMT

Hi Aggr function is used when you want to find the totals of an expression or to aggregate the data for given dimensions present in the chart. Most of the time when you use if statement when defining expression then your totals gets messed up in the pivot table. Below is the example of the aggr:

sum(aggr(if($(CAT_BGT_Cy_Margin%)>$(BB_ACT_Margin%),$(BB_Rev_ActualvsBudget),0),[Item type],ItemTypeDesc,Style,Name))

From qlikview Help:

aggr ([ distinct | nodistinct ] [{set_expression}]expression {, dimension})

Returns a set of values of expression calculated over dimensions. The result can be compared to the expression column of a 'local chart', evaluated in the context where the aggr function resides. Each dimension must be a single field. It cannot be an expression (calculated dimension).

If the expression argument is preceded by the nodistinct qualifier, each combination of dimension values may generate more than one return value, depending on underlying data structure. If the expression argument is preceded by the distinct qualifier or if no qualifier is used at all, each combination of dimension values will generate only one return value.

By default, the aggregation function will aggregate over the set of possible records defined by the selection. An alternative set of records can be defined by a Set Analysis expression.

By using this function in Add calculated dimension... it is possible to achieve nested chart aggregation in multiple levels. See also Nested Aggregations and Related Issues.

When used in chart expressions it is possible to achieve Sum of Rows in Pivot Tables.

Examples:

aggr( sum(Sales), Country )

aggr( nodistinct sum(Sales), Country )

aggr( sum(Sales), Country, Region )

count( aggr( sum(Sales), Country ))

If you have any issue with application post your problem we can be able to help you

Re: Aggr Function ?

ashfaq_haseeb — Fri, 31 Oct 2014 18:27:11 GMT

Hi,

Check this

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr

http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/19/function-classes#comment-17143

Regards

ASHFAQ