Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

Hi

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

0 Replies