Aggr and Inter-chart functions

Thu, 19 May 2011 11:42:26 GMT

Hi,

Can Aggr() and Inter-chart functions be used together if the when the both are on a field that's not a dimension in the chart.

To illustrate I'll use my own problem:

Here is the dummy data of sales per consultant, with a 3 month rolling average.

Now this works fine. But if I want to calculate the average of each consultants' rolling averages in a straight table. The expression I used was:

Avg(Aggr(RangeAvg(Above(Sum(BASE),0,3)),CONSULTANT,[SALE CAPTURE YM]))

With Consultant as my only dimension.

But this obviously didn't work, and I assume it's because of the Above() function.

Is what I'm trying even possible. Please, if someone can point me in the right direction?

topic Aggr and Inter-chart functions in QlikView