aggr() in combination with above() returns null?

Wed, 30 Dec 2009 17:13:37 GMT

I try to eval the minimum value in a dimension above a given threshold

aggr (min ( if (bincount > 7 , bincount) ), dim )

which works fine for e.g.

dim=1, (ordered) values=3,1,4,8,5,1 evals to 8
dim=1, (ordered) values=7,18,1,5,1 evals to 18

Instead of bincount I however need the accumulated bincount value. If I use

if (rangesum(above(bincount,0,rowno())) > 7, bincount)

I get the correct values displayed in my straight table expression column

dim=1, (ordered) values=3,1,4,8,5,1 evals to -,-,4,8,5,1
dim=1, (ordered) values=7,18,1,5,1 evals to -,18,1,5,1

Trying to get the minimum value for this accumulated value however returns null for all variants I tried

aggr ( min ( if (rangesum(above(bincount,0,rowno())) > 7, bincount) ), dim)

Jürg

topic aggr() in combination with above() returns null? in QlikView