split an aggr function by non aggregate dimension

[Gestion-PSD]

Hi all!

I've a problemn with an aggr function. I hope I could explain myself.

What we want is to "split" the results of an aggr function by one dimension that was not used in aggregation. 

I mean, using the data and aggr function used as example in Qlik Help:

Sum(Aggr( Rangesum(Above(Sum(Sales),0,12)), (Year, (Numeric, Ascending)), (Month, (Numeric, Ascending)) ))

if I try to show a table with Year, Month and OrderID as dimensions, all rows but one per year/month shows zeros.

This is the table with Year and Month dimensions:

But, when I add OrderID as dimension:

What we want is to populate all these rows. I mean, What I want is something like if I were using a bunch of aggr functions, one for each OrderID aggregating by Year & Month

Best regards,

Alonso Torres

[brunobertels]

Hi 

may be this 

Sum( TOTAL Aggr( Rangesum(Above(Sum(Sales),0,12)), (Year, (Numeric, Ascending)), (Month, (Numeric, Ascending)) ))

[Gestion-PSD]

Hi Bruno

It doesn't work.

With TOTAL in that position, the table shows te total sum (4123876) in all rows.

Moreover, if I try to put "Total" modifier after Rangesum(, the result is all zeros; and if I try to put it as sum(total Sales), results are also wrong.

Thanks,

Alonso Torres.