Above function help - chart function

[hamish2]

Hello I am fairly new to qlik, so maybe there’s a way to do this which I don’t understand. I am using the Above() function nested in RangeSum() which essentially gives me the sum of an array. However, I would the 3rd parameter, count, to be dynamic - change accounting to the number of dates available for a particular year. Can someone please help me with this? Thanks

[anat]

above(sum(Sales),1,round(YearEnd(Today())-YearStart(Today())))

[henrikalmen]

You should be able to use an expression instead of an explicit number, something like:

above(sum(x), 0, GetPossibleCount(datedimensionname))