topic Re: Before() with Aggr() - Doesn't Work in QlikView

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

tresB — Tue, 27 May 2014 09:12:34 GMT

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?

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

Tue, 27 May 2014 09:19:50 GMT

try this:

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

in pivot

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

tresB — Tue, 27 May 2014 09:24:39 GMT

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?

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

Tue, 27 May 2014 09:30:03 GMT

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

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

tresB — Tue, 27 May 2014 09:33:21 GMT

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