Above function help - chart function

[keronbwan]

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

PS - I am trying to solve for a Year To Date calculation, but I think this is what I need to fix. Let me know if this makes sense. Thanks

[Rohan]

Hi Keron,

Try something like :

Rangesum(above(total Measure), 0, $(=Count({<Date={">=$(=date(yearstart(max(Date),0,4))) <=$(=Date(max(Date)))"}>}distinct Date)))

Let me know if it worked out for you.

Regards,

Rohan.