Before() with Aggr() - Doesn't Work

[tresesco]

I had been working on a case in response to this :Re: Re: Re: Re: Including unselected data in before-function . And that lead me to use expression like: = Sum(Aggr(Before(Sum({<Month>}Amount)),Month))         // in a pivot with Month as dimension

                    and this expression fails while it's counter-part with above() works fine.

                          = Sum(Aggr(Above(Sum({<Month>}Amount)),Month))          // in a straight table with Month as dimension

Info: QV 11 SR5

Am I missing somethin? Or, is it a Bug?

[#2]

try this:

Sum(Aggr(Above(Sum({<Month>}Amount)),Month)) 

in pivot

[tresesco]

Strange! my pivot's Month is  dragged to column and hence before() is the one which should work there. But yes Above() works. Do you have any logical explanation for that?

[#4]

i think, that in fact we are no in pivot but in virtual table created by aggr() ....

[tresesco]

Makes sense. But then qlik has to say that before() would not work with aggr().