topic Re: split an aggr function by non aggregate dimension in App Development

split an aggr function by non aggregate dimension

Gestion-PSD — Wed, 08 Sep 2021 11:21:40 GMT

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

Re: split an aggr function by non aggregate dimension

brunobertels — Wed, 08 Sep 2021 12:50:18 GMT

may be this

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

Re: split an aggr function by non aggregate dimension

Gestion-PSD — Thu, 09 Sep 2021 10:01:59 GMT

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.