Solved: Why Aggr() in straight and pivot table? - Qlik Community

surajap123 · ‎2014-05-20

Hi All,

I always have this doubt about why to use Aggr(which is group by in sql) in straight table and pivot table.

As far as i know the straight table or pivot table will group the expression result(say, sum(sales)) automatically based on the dimension used.

So ultimately, the row in the straight/pivot table will have the aggregated value beside its corresponding dimension.

So why to use aggr?

hic · ‎2014-05-20

You are absolutely right. Aggr() should usually NOT be used.

However, if you want a nested aggregation, then you should use Aggr(), e.g.

Average of (Sum of sales per Month) = Avg(Aggr(Sum(Sales),Month))

HIC

See also

alexandros17 · ‎2014-05-20

Aggr can aggregate values on dimension different from the one used in the chart ...

hic · ‎2014-05-20

You are absolutely right. Aggr() should usually NOT be used.

However, if you want a nested aggregation, then you should use Aggr(), e.g.

Average of (Sum of sales per Month) = Avg(Aggr(Sum(Sales),Month))

HIC